I complete a roster for an emergency department, I am trying to adjust my spreadsheet so that I only need one conditonal format.
This is what I have managed to acheive so far,
=IF(OR(F3="10L"),OR(H3="7L"),IF(OR(F3="15S",F3="12L",F3="19L",F3="2130S"),OR(H3="7S",H3="7L")))
When this is true the cells I need are highlighted red so that I can identify an error in someones roster, I still need to enter more conditions but am struggling to make it work. I am also applying it to multiple adjacent cells, which is working.
if a staff member is rostered the following shifts on consecutive days (ie mon/tues, or tues/wed) I need the cell highlighted,
MONDAY TUESDAY
19L OR 2130S 7L OR 7S OR 10 OR 10L OR 12 OR 12L OR 1330S OR 15S
15S 7L OR 7S
10L 7L OR 7S
12L 7L OR 7S OR 10L
Bookmarks