0

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.

1
  • try =Q2=DATE(YEAR(P2),MONTH(P2),DAY(P2)+7) Jun 6, 2016 at 15:01

1 Answer 1

1

You should be able to use the formula below to accomplish this.

=Q2>(P2+7)

This will compare Q2 with the date in P2 plus 7 days. If it is greater than 7 days past P2, it returns true and changes the fill.

enter image description here

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .