Articles

Solved change excel cell colour using If

February 11, 2005 at 10:34:20
Specs: windows xp, 1.3

I am trying to change the colour of a cell using the "If Function" i.e. If value of the cell is greater than 20, change colour of cell to green, else colour to be red.



See More: change excel cell colour using If

Report •


#1
February 11, 2005 at 16:24:14

Hi
Try using Format>Conditional Formating.



Report •

#2
February 14, 2005 at 10:44:52

Thanks for the reply but i didn't really understand it. Could you please give me an example of the function that would relate to my earlier question.

Thanks


Report •

#3
February 16, 2005 at 04:33:53
✔ Best Answer

Hi
Select all the cells you want coloured then select Format>Cells>Pattern Tab and select your red color, to color all the cells.
Select them all again and select Format>Conditional Format and select or enter these values.

| Cell Format is | between | 20 | 1000 |
then select your Format>Patterns from the same dialog and choose you green color.
Change the 1000 to your own upper limit.


Report •

Related Solutions


Ask Question