Copper Contributor



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. 



1 Reply


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




Click Format...
Activate the Fill tab.
Select red.
Click OK, then click OK again.