I have a query regarding conditional formatting in Excel 2010. I have a date in cell P2
.
The function I would like is:
In cell Q2
if a date is entered that is 7+ days after the date in cell P2
, the colour of the cell (or text) changes to red.
How may I achieve this?
I have tried entering the conditional format for Q2
as
=DATE(YEAR(P2),MONTH(P2),DAY(P2)+7)
to no avail.
If anyone could point me in the right direction, I'd really appreciate it.
=Q2=DATE(YEAR(P2),MONTH(P2),DAY(P2)+7)