Date
If the Date is entered into A1
Enter the formula
=A1+3 into the next cell and copy / paste down or across as required.
Use Format-Conditional Formatting to control the cell background colours
based on the condition(s) required.
Cheers
Nigel
"Sanjeev" wrote in message
...
Hi,
I have entered a date in a cell. I would like the next cell to take the
date automatically +3 days from the pervious cell and the colour should
change after the actual date is equal to +3days.
|