Jagdev
03-17-2015, 02:43 AM
Excel CF help
Could you please help me with the CF formula which will change the color of the cell whenever the date is changed to 7 days after the applied date?
Say in the attached sample the date in column A is 17th March and it will be fixed throughout the column A. In case if someone changes the date to 25th March or above, it should change the cell color. Till the date 24th it should not change it color and from 25th and above change the color of the cell
Regards,
JD
Could you please help me with the CF formula which will change the color of the cell whenever the date is changed to 7 days after the applied date?
Say in the attached sample the date in column A is 17th March and it will be fixed throughout the column A. In case if someone changes the date to 25th March or above, it should change the cell color. Till the date 24th it should not change it color and from 25th and above change the color of the cell
Regards,
JD