Excel 2007 - Change cell color using If [Solved/Closed]

Question

Excel 2007 - Change cell color using If [Solved/Closed]

Report

ja6924 - Apr 28, 2010 at 06:57 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- 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?

Excel 2007 - Change cell color using If
Excel vba change cell color based on value ✓ - Forum - Programming
Excel vba change cell color - How-To - Excel
Excel vba - change cell color based on value ✓ - Forum - Office Software
Excel auto change cell color based on value ✓ - Forum - Excel
Change color to different cells based on another cells text. ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2010-04-28T08:36:13-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

763
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

Excel 2007 - Change cell color using If [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!