Conditional Formatting to turn cell different colors

**blackshag** · 11-02-2012, 07:14 PM

What is the appropriate formula?

I would like cell D4 to turn green if:
C4=F1

I would like cell D4 to turn red if:
M4>7

I would like cell D4 to stay empty (or white) if:
M4<7 or if C4 is empty

**FDibbins** · 11-02-2012, 07:23 PM

you need to use cnditional formatting to do this

find it in the home tab/styles
1. highlight D4 and any other cells in that range you want this to apply to
2. click on CF, select NEW RULE and USE FORMULA.
3. type in =C4=F1 - format as green
4. click on CF, select NEW RULE and USE FORMULA.
5. type in =M4.7 - format as red

let me know how you make out?

**blackshag** · 11-02-2012, 07:38 PM

Thank you. Works out except when both C4=F1 AND M4>7. It stays red.
I would like the C4=F1 to trump any other formula. Any suggestions?

**FDibbins** · 11-02-2012, 07:46 PM

in the main CF window, on the right, you can change the order of the rules

**blackshag** · 11-02-2012, 07:49 PM

Worked like a charm! Thank you

**FDibbins** · 11-02-2012, 07:52 PM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and thanks for the rep