Formatting

Copper Contributor

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 

1 Reply

@Browny3649 

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.