Hi All,
Hoping someone can show me the light.
In the workbook I have, the cell colour of the columns and rows is white.
I have a cell on the far right of these columns which will be used for entering a date.
Is there any way that when the date is entered into this cell I can then have excel automatically change the cell colour for a given number of cells in the row to blue? (including the date cell).
I want to use this a a quick look for people to see which entries in the workbook have been complete.
Thanks
Jason.
Hoping someone can show me the light.
In the workbook I have, the cell colour of the columns and rows is white.
I have a cell on the far right of these columns which will be used for entering a date.
Is there any way that when the date is entered into this cell I can then have excel automatically change the cell colour for a given number of cells in the row to blue? (including the date cell).
I want to use this a a quick look for people to see which entries in the workbook have been complete.
Thanks
Jason.