I have created a convoluted formula which responds true or false which is then formatted conditionally to colour-in cells in a date range.
Row 2 has a calendar year of dates (e.g. H2 = 31/01/13, H3 = 01/02/13, H4 = 02/02/13 and so on)
And columns have the date ranges:
Column F3 = 31/01/13
Column G3 = 05/02/13
Column H3 =AND(H$2>=$F3,H$2<=$G3)
Which therefore colour-in the cells which respond true to the relevant formula.
What I'd like to do is to have a monthly event occurring and coloured in - e.g.
F3 = 31/01/13; 28/02/13; 31/03/13
G3 = 02/02/13; 02/03/13; 02/04/13
So the result would be that "true" would come up in the relevant cells on and in-between these dates and therefore they would be formatted with colour!
"," and "AND" and ";" don't work - is there something else I could use?
Thanks ever so much!