Conditional format if not workday

**ioncila** · 05-26-2009, 05:51 AM

Hi
Maybe I'm getting a blank, maybe the answer is so easy, but lately I can´t solve this:

How do I use conditional format to change cell color if cell value (date) is not workday?

Any help would be nice

Thank you all

**dominicb** · 05-26-2009, 07:11 AM

Good afternoon ioncila

Originally Posted by ioncila

How do I use conditional format to change cell color if cell value (date) is not workday?

If the target cell is A1, then set the dropdown to Formula Is and use this formula :
=OR(WEEKDAY(A1)=7,WEEKDAY(A1)=1)

HTH

DominicB

**ioncila** · 05-26-2009, 07:20 AM

Thanks for the reply but my issue is more deeply (my fault if I didn't say it it cleary).

What you have suggested I already did but I have also a range of holidays that are not workdays too.

What I'm trying to avoid is a OR function to large.

**dominicb** · 05-26-2009, 08:08 AM

Hi ioncila

Originally Posted by ioncila

What I'm trying to avoid is a OR function to large.

In which case, I assume you have a list somewhere of non-working days?
Still assuming that the day to test is in A1 and your list of non-working days is occupying the range E1 - E10, then something like this should work OK :
=COUNTIF(E1:E10,A1)>=1

HTH

DominicB