How to do conditional colour fill.
Closed
t_subhash
Posts
1
Registration date
Sunday June 19, 2016
Status
Member
Last seen
June 19, 2016
-
Jun 19, 2016 at 04:16 AM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Jun 19, 2016 at 11:43 PM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Jun 19, 2016 at 11:43 PM
Related:
- How to do conditional colour fill.
- Crimping colour code - Guide
- Setting the window colour will change the colour of ✓ - Windows Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Conditional formatting if another cell contains - Excel Forum
- Io box to rj45 colour coding - Network Forum
1 response
fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Jun 19, 2016 at 11:43 PM
Jun 19, 2016 at 11:43 PM
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AK3 >= D3...format fill GREEN
You could save a CF rule by having all cells formatted as green, then just use this instead...
=AK3 <> D3...format fill RED
Or, if you want 2 rules, just use them both
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AK3 >= D3...format fill GREEN
You could save a CF rule by having all cells formatted as green, then just use this instead...
=AK3 <> D3...format fill RED
Or, if you want 2 rules, just use them both
