Hello all,
I am trying to create a VBA routine that will check the dates in column G, if those dates are within two weeks from Today then for the row in which that date appears to be filled RED and the font YELLOW.
The Range of cells containing my data is A1: I26
Column G contains dates and text, I want the routine to skip any cells in Column G which contain text.
Finally, I want a seperate routine that will allow me to remove just the formatting which the first routine my have inserted.
Any suggestions much appreciated
MZP