View Single Post
  #2   Report Post  
GoBow777 GoBow777 is offline
Member
 
Posts: 58
Default

Quote:
Originally Posted by Johnny View Post
Help..
In sheet 1 I have a list of public holidays which I would like to show as a
highlighted cell in another sheet. ie I have twelve X month sheets, Jan,
Feb, etc
In row B3 I have the month date as 01-Jan and so on for the rest of the month.
Is there a formula that will also highlight a second or third date in that
month as well.
I am trying to do a roster and by having all the holidays in sheet 1 making
it far easier to roster staff accordingly.
Any help would be greatful
--
Johnny
Johnny try this.
Attached Files
File Type: zip Johnny.zip (4.5 KB, 151 views)