conditional format sum if

[Micayla]

i would like to put in a conditional format for cell A3.
in cells A1 and A2 i have dates and i want the formatting
in A3 to come into effect if A2-A1 is greater than 9 days
but i cannot get the right formula.
many thanks if anyone can help.

 

[JE McGimpsey]

One way:

CF1: Formula Is =(A2-A1)>9

 

[Guest]

Excellent, thank you.
Now i can see however that by copying the formatting to
the following cells in the table all the blank ones come
up coloured as well. i have tried added another rule so
that if there is no date in A1 then no formatting comes up
in A3 but nothing has happened. do i need to change the
formula in the 2nd format or add something to the first?

 

[JE McGimpsey]

One way:

CF1: Formula is =AND((A2-A1)>9, LEN(TRIM(A1))>0)

or, if you want to make sure both A1 and A2 have entries:

CF1: Formula is =AND((A2-A1)>9, COUNT(A1:A2)=2)