Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do I format 1 column of alphabetical listings into 3 columns? | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |