Excel 2007 - Change cell color using If
Solved/Closed
ja6924
-
Apr 28, 2010 at 06:57 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Excel 2007 - Change cell color using If
- Excel vba - change cell color based on value ✓ - Forum - Programming
- Excel vba change cell color - Guide
- Changing a cell value based on the color of a ✓ - Forum - Office Software
- VBA: Color cells in table based on multiple condition ✓ - Forum - Excel
- Change color to different cells based on another cells text. ✓ - Forum - Excel
1 reply
rizvisa1
Apr 28, 2010 at 08:36 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
=a1< .6
and
=a1 <= .7
For each formula, you would then use click the format button under conditional formatting dialogbox and choose your color