Using Conditional Formatting to Match Scheduled Days Off

**SELFCLOATHING** · 10-20-2016, 10:00 PM

Schedule.PNGHello! I work at a hotel and I have a problem of tracking my Housekeeper's days off after I make changes one week so I want to create formatting to highlight cells that say OFF in red if they don't match the reference cells of their actual days off if that was listed to the right using Serial codes to mark. I was trying to think of how to do this using the WEEKDAY Serial codes (Mon-Sun).

So pretend my days off are Monday (1) and Tuesday (2) but I am scheduled this week Wednesday(3) and Thursday(4) - how can have my incorrect OFF days change the color of the cells?

**jeversf** · 10-20-2016, 10:21 PM

Hi selfcloathing

you can use the or formula:

=OR(C$4=$K5,C$4=$L5)

as in the attached.

**SELFCLOATHING** · 10-21-2016, 08:24 AM

Thanks Jeversf - it looks like you put a formula within the cell which doesnt allow me to type in the shift each week. Is there a way for it to recognize that a cell does not equal "OFF" and change the color of the cell or text?

**jeversf** · 10-23-2016, 07:37 PM

You can delete the formulas in the cells selfcloathing, I only put them there to test the formula. the conditional formatting is only dependent on the header (row 4) and the days off (columns K & L).

Using Conditional Formatting to Match Scheduled Days Off

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Using Conditional Formatting to Match Scheduled Days Off

Re: Using Conditional Formatting to Match Scheduled Days Off

Re: Using Conditional Formatting to Match Scheduled Days Off

Re: Using Conditional Formatting to Match Scheduled Days Off

Thread Information

Users Browsing this Thread

Similar Threads

Calendar formatting using conditional formatting (week, month and special days)

Conditional formatting to go by hours and not days?

Conditional formatting for <45, 45-90, >90 Days

[SOLVED] Conditional Formatting +-4 days

Distribute hours across scheduled days...

Conditional formatting to highlight already conditional formatted days

Conditional Formatting date more than 5 days old

Bookmarks

Bookmarks

Posting Permissions