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.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
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.
Please Login or Register to view this content.
HTH
Cheers guys i've sorted it.
Leeroy1401
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks