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
Last edited by NBVC; 11-05-2008 at 11:07 PM.
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.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
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.
Then just copy B6 and Paste Special Formats to all your other dates.Code:=NOT(ISERROR(MATCH(B6,holidays,FALSE)))
HTH
Cheers guys i've sorted it.
Leeroy1401
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks