A through F should reference C18 and the formula should be locked ($C$18).
In C18, just give it its own condition (Cell value equals "complete"...red).
If this is not working, check your cond format formulas because it
automatically put in quotes. (ie all you need to type is C18=complete, not
C18="complete"...because it will change it to C18=""complete"" which won't
work.)

"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?