View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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.