Colouring a MS Excel Cell [Solved/Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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.

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2838 users have said thank you to us this month

Hi,

Many thanks for writing back.

The version of my Excel is 2007.

Many thanks.
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
see help in excel 2007 and you will find the answer