Previous Topic Next Topic

Colouring a MS Excel Cell

Solved/Closed
Anthony - Sep 9, 2010 at 05:40 AM
venkat1926 Posts 1863 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.
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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
Anthony
Oct 17, 2010 at 11:20 PM
Hi,

Many thanks for writing back.

The version of my Excel is 2007.

Many thanks.
Answer 2 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 18, 2010 at 09:03 PM
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
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses