Ahh -- I didn't get that I could do that... though I was picking up on the
fact that it was overwriting the other one.

But that's great, thanks.... again.

"bj" wrote:

do the A:F conditional format first
select column C and write over the conditonal formating with both the gray
shade and red font as the format
if you put in two conditional format with the same criteria, only the first
one will take effect.

"MatthewTap" wrote:

I currently have two conditional formats, and I'm only able to have one work
or the other.

Specifically for example, I have columns A through F populated, and when C18
is populated with "Complete" I want two things to happen:

1) A18:F18 are shaded Gray.
2) C18's font format changes to Bold Red

Currently I can do them individually via the following:

1) Highlight columns A:F, then put Formula in Cond Format this:
=$C1="Completed"


2) Highlight Column C, and put Cell Value in Cond Format:
equal to "Completed"



But, I can't do both at the same time... the rows gray out but the Red does
not work.

Any thoughts on mixing the two?