Excel 2007 - Change cell color using If
Solved/Closed
ja6924
-
Apr 28, 2010 at 06:57 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 28, 2010 at 08:36 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 28, 2010 at 08:36 AM
Related:
- Excel 2007 - Change cell color using If
- Save as pdf office 2007 - Download - Other
- How to change date format in excel - Guide
- Excel if cell color is red then - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Apr 28, 2010 at 08:36 AM
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