Forum Discussion
Formulas & Conditional Formatting
Jkey1990 , it works as in attached, all rows with CCD role are with red font.
SergeiBaklan Not quite what I'm looking for unless I entered the suggestion the wrong way, which is entirely possible.
I'm going to copy/paste the text from the table I'm using to give a better idea. The total table includes 170+ (I'll be doing multiple) names and has drop-down boxes for a total 10 possible roles. I need the conditional formatting to change the text color (say, to red) of any text in a row that contains CCD. Then I would do an additional rule for Pushback (change to blue) and so on until each of the more important roles would change color when a letter code is entered into a row that contains that role.
When I tried entering the suggestion it changed all of the letter codes into the same color whenever the role was selected in the role column.
(Some of it was cut off in order to post, the important bits are in the right spot though.)
| Month | Dates of Absence | Year | |||||||||||||||||||||||||||||||
| Name | Role | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | |||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | |||||
| Employee 1 | CCD | V | V | V | V | V | C | C | |||||||||||||||||||||||||
| Employee 2 | Pushback | c | S | S | I | S | V | V | V |
Jkey1990 , it works as in attached, all rows with CCD role are with red font.
SergeiBaklan Oh I feel like an idiot. I didn't set the "applies to" correctly. Thank you for the example so I was able to see where I was messing up. It irks me that it was so simple, but I am so glad to be able to get closer to finishing this. Thank you, sir.
Jkey1990 , no problem, you are welcome