Right now, I'm trying to come up with a one line entry that can cover three instances.
Basically, I have a row of names in column F, and a reflection of scheduling in column G. I'm trying to write conditional formatting to flag a cell red if somebody is listed as OFF, TRAINING, or PTO. As opposed to writing in three separate formattings:
=VLOOKUP(C2,$F$2:$G$12,2,0)="OFF"
=VLOOKUP(C2,$F$2:$G$12,2,0)="TRAINING"
=VLOOKUP(C2,$F$2:$G$12,2,0)="PTO"
How would I combine that into one line? I'm sure it's just one silly punctuation, but my rote google searches are turning up nothing. The actual cell references are fairly irrelevant for my question, just representing where it's at. Any help would be appreciated. Thanks!
Bookmarks