Previous Topic Next Topic

Excel 2007 - Change cell color using If

Solved/Closed
ja6924 - Apr 28, 2010 at 06:57 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 28, 2010 at 08:36 AM
I have a cell with a % in it. I would like that cell color to change to red if the percentage is below 60%, and change to yellow if it is between 60% & 70%, no change if above 70%. I would like to use a fomula to do this. Perhaps the If formula. How do I do this?

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 28, 2010 at 08:36 AM
Use conditional formatting for this. You would need to enter two conditions

=a1< .6
and

=a1 <= .7

For each formula, you would then use click the format button under conditional formatting dialogbox and choose your color
9

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Counting cells containing only numbers
jutulu -
jutulu -

4 responses