Hi All,
I have a custom annual calendar which I am looking to highlight with scheduled items. For each of these there is and start and end date laid out in columns as shown below.
Item Start Date End Date Party 14 May 2013 15 May 2013 Holiday 20th May 2013 26th May 2013
For a single item I would simply use the following conditional format, with A1 being the cell containing a date:
However for multiple items, I want to use a named range for 'Start_Date' and 'End_Date' so that they all use the same formatting.=AND(A1>=Start_Date,A1<=End_Date)
Any suggestions?
Thank you!
Oliver
Bookmarks