Column A = date of referral, Column B = date patient is seen 

I would like the cell in column B to turn green if the patient is seen within or at 6 weeks (42 days), and red if exceeded.

Green formula =B1<(A1+43)

Red formula =B1>(A1+42)

This works in row 1, but I can’t seem to apply the same formula to all rows? 

Many thanks in advance for your help. 

​Column A = date of referral, Column B = date patient is seen I would like the cell in column B to turn green if the patient is seen within or at 6 weeks (42 days), and red if exceeded. Green formula =B1<(A1+43)Red formula =B1>(A1+42) This works in row 1, but I can’t seem to apply the same formula to all rows?  Many thanks in advance for your help.   Read More

​