Cond Format -- on set of columns, then one column
 

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?

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?

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?

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?