Forum Discussion
Formatting
Hello,
I am trying to get date columns to react to each other. In one column I will enter a date, in the other column I would like it to populate a date 28 days post the original date and for it to turn red once the date has past the 28 day period.
Thanks
Let's say you enter dates in A2 and down.
In B2, enter =IF(A2="","",B2+28) and fill down as far as you want.
With the range in column B still selected (and B2 the active cell in the selection):
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=AND(B2<>"",B2<TODAY())
Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.
