01/09
02/09
03/09
04/09
05/09
06/09
07/09
08/09
09/09
10/09
11/09
11/09
12/09
13/09
14/09
15/09
16/09
Code:
An Excel sheet with column of short dates 01/09-16/09 as above I want to enter a short Date in a cell and the background change to yellow
Say I enter 03/06 then the column cell would change and then with a formula so that every six days would also change to yellow 09/09 and 15/09