I am trying to conditionally format a duty calendar that has each duty shown in a font of a specific color.
If the person is off duty the font remains black, but the cell is shaded gray if it says OFF and yellow if it says VAC or PFH.
Each cell contains the duty name and an ALT+ENTER to put the duty hours on a separate line. In conditional formatting, I was using this
Formula Is =NOT(ISERROR(SEARCH("ASE/Page 1*",B3))) and selecting a dull blue font color for the ASE/Page 1 duty. I did this for three of the duties and it worked fine, but I need more than three.
Here is a list of the duties and corresponding colors:
ASE/Page 1 ... dull blue
Page 2/rim ... green
Slot ... purple
Rim ... red
Early ... dark orange (Any cell that has early in it should be dark orange font)
Agate ... bright blue
Can anyone help?
If the person is off duty the font remains black, but the cell is shaded gray if it says OFF and yellow if it says VAC or PFH.
Each cell contains the duty name and an ALT+ENTER to put the duty hours on a separate line. In conditional formatting, I was using this
Formula Is =NOT(ISERROR(SEARCH("ASE/Page 1*",B3))) and selecting a dull blue font color for the ASE/Page 1 duty. I did this for three of the duties and it worked fine, but I need more than three.
Here is a list of the duties and corresponding colors:
ASE/Page 1 ... dull blue
Page 2/rim ... green
Slot ... purple
Rim ... red
Early ... dark orange (Any cell that has early in it should be dark orange font)
Agate ... bright blue
Can anyone help?