How to do conditional colour fill.
Closed
t_subhash
fdibbins
- Posts
- 1
- Registration date
- Sunday June 19, 2016
- Status
- Member
- Last seen
- June 19, 2016
fdibbins
- Posts
- 33
- Registration date
- Sunday June 19, 2016
- Status
- Contributor
- Last seen
- November 20, 2016
Related:
- How to do conditional colour fill.
- Black and white video to colour converter free download - Download
- Resistor colour code calculator download - Download
- If cell contains text then return value multiple conditions ✓ - Forum - Excel
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Colour code for crimping - Guide
1 reply
fdibbins
Jun 19, 2016 at 11:43 PM
- Posts
- 33
- Registration date
- Sunday June 19, 2016
- Status
- Contributor
- Last seen
- November 20, 2016
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