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...
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.
