I have worked out how to colour a cell based on a date ($E4) that falls within the week of another date ($I3). = WEEKNUM($E4,1) = WEEKNUM(I$3,1)
I would like to change the colour at this junction dependent on the selection at c4 but the rest of the criterion remains the same?
= WEEKNUM($E4,1) = WEEKNUM(I$3,1)
Thanks in advance.
Bookmarks