Hi Xor
Many thanks for your prompt response. Apologies for not making my request clearer. Across the top of my worksheet I have a series of week ending dates (row 6). Where a date in col B or C falls within each of these weekending dates I want to populate that cell with a "0" where I will use conditional formatting to colour each cell that matches.
A sample worksheet is attached for clarity.
Thanks in advance.
Tony
|