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.