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
Dear CCM team

I want to have cell colour of cell AL3 to green if AK3 > or = D3 and the colour should be red if it do not meet this condition. Kindly help.

1 reply

fdibbins
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
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
0