How to do conditional colour fill.
Closed
t_subhash
Posts
1
Registration date
Sunday 19 June 2016
Status
Member
Last seen
19 June 2016
-
19 Jun 2016 à 04:16
fdibbins Posts 33 Registration date Sunday 19 June 2016 Status Contributor Last seen 20 November 2016 - 19 Jun 2016 à 23:43
fdibbins Posts 33 Registration date Sunday 19 June 2016 Status Contributor Last seen 20 November 2016 - 19 Jun 2016 à 23:43
Related:
- How to do conditional colour fill.
- Rj45 colour code - Guide
- How to change text colour html - Guide
- Sound card colour code - Guide
- Excel conditional formatting based on date - Guide
- Excel if colour - Guide
1 response
fdibbins
Posts
33
Registration date
Sunday 19 June 2016
Status
Contributor
Last seen
20 November 2016
1
19 Jun 2016 à 23:43
19 Jun 2016 à 23:43
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
