Conditional formatting

[leeroy1401]

I am creating a register and have got a worksheet with everyone name and dates across the top, the dates are automatically created by entering one date, the dates are weekly. But i want to show when we are on holiday, could i do this by using conditional formatting and if yes, how and if no how else can i do this.

Leeroy1401

[NBVC]

You would have to create a list of holiday dates somewhere in the spreadsheet and then name that list something like "Holidays" (without quotes).

Then your conditional format formula would be something like:

=Match(A1,Holidays,0)

where A1 is cell to format.

[Richard Buttrey]

Hi and welcome to the forum.

You'll need to first create a list of your holidays, and then name the range "holidays"

Now use the 'Formula Is' option within the conditional formats. Assuming you have a date in B6, add the following CF to B6 and set the format as necessary.

=NOT(ISERROR(MATCH(B6,holidays,FALSE)))

Then just copy B6 and Paste Special Formats to all your other dates.

HTH

[leeroy1401]

Cheers guys i've sorted it.