Scheduleing Employee Twice
Not True. True would mean they both have any data. It is when the two cells
havve the same value.
=(B4=H4)
If B4 equal s H4 then you get a true condition. If they are unequal you
will get a False condition.
You could set two conditional conditions. Blue when not equal and Red when
equal
=(B4=H4) Red
=(B4<H4) Blue
"Matlock" wrote:
I set the Format Condition for Blue when they are TRUE.
For Monday B4 through B23 are Dropdown Menus.
20 Total, 1 for each position. For Dayshift.
Same for Night which is H4 through H23.
|