Colouring a MS Excel Cell

Solved/Closed
Anthony - Sep 9, 2010 at 05:40 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 18, 2010 at 09:03 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 9, 2010 at 06:11 AM
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
Hi,

Many thanks for writing back.

The version of my Excel is 2007.

Many thanks.
0
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Oct 18, 2010 at 09:03 PM
see help in excel 2007 and you will find the answer
0