condition format

[james rockford]

Hello to all,

I have a calendar and I am looking for help to show stat holidays
I have a list of days and what I am looking to do is highlight the cell to show the holiday on the calendarcan so one show me the way it would be a big help

thanks

 

[Momentman]

Conditional formatting should come in handy

Maybe a formula like =NOT(ISERROR(VLOOKUP(CalendarDate, CalendarLit,1,0)))

it should return TRUE when the date is on the list and FALSE if its not

There are many ways to tackle it but without having much more information about ur set up, it is difficult to say

 

[james rockford]

HI Momentman,
Thanks for your help and yes poor explanation so let me paint the info
I have a calendar set up and I have a row of dates are pulled from this formula COLUMNS($D13:AA13)+(ROWS(AA$13:AA13)-1)*7-$C$4+$C$3
Now I have set up a list by month of the holidays I.E Dec Dec 25 and 26
So what I need to do is highlight the dates to show this as a stat day off

I hope this help and again thanks for your help