Previous Topic Next Topic

Colouring a MS Excel Cell

Solved/Closed
Anthony - 9 Sep 2010 à 05:40
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 18 Oct 2010 à 21:03
Hello,

I need some help.

How could I fill a cell in MS Excel in red if a condition has been met. For example:

If the number in Cell A1 is more than 75, Cell C10 is filled in blue
if the number in Cell A1 is equal to and between 75 and 50, Cell C10 is filled in Green
If the number in Cell A1 is equal to and between 49 and 25, Cell C10 is filled in Yellow
If the number in Cell A1 is less than 25, cell C10 is filled in red
If Cell A1 is empty, do nothing

Many thanks.
Related:

2 responses

Réponse 1 / 2
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
9 Sep 2010 à 06:11
if your versions is excel 2007 you can do this by conditional formatting. if earlier versions conditional formatting can have only three conditions. in that case you need a macro. post back the name of your version
Anthony
17 Oct 2010 à 23:20
Hi,

Many thanks for writing back.

The version of my Excel is 2007.

Many thanks.
Réponse 2 / 2
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
18 Oct 2010 à 21:03
see help in excel 2007 and you will find the answer

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses