Conditional Formatting Cell and Row

[marcy]

I am trying to set up CF for a row to grey if cell $M14 reads yes.
I was able to do this using this formula:
Condition1: =$m14="yes"
formatting=grey gorund

BUT, I wanted to add a condition as follows:

Condition2: =AND($m14="",,$h14<>"",TODAY()-$h14>=5)
formatting = red ground

Here's the problem: I highlighted the entire row in order to accomodate
condition 1 but after adding condition 2, the whole row turns RED when I only
want the M cell to be red. So, how can I CF for the row to show the line
item is complete but still accomodate condition 2 if it is not?

Thanks in advance for any help you can share.

 

[JulieD]

Hi marcy

you can have up to three conditions on one range in excel using CF
therefore put the condition that you want to have checked first as the first
condition ... and format it appropriately
then click the ADD button
now set up the condition that you want to be tested if the first condition
evaluates to false

etc

hope this helps
Cheers
JulieD