Conditional Formatting (Dates) Repost with additional data

B

BigH

Hopefully someone can help, I posted the question below yesterday and got
the correct answer for my question, however I didnt include all the
information required. The additional information is
cell A2<A1 and cell A3 equals A2, then make cell red else make cell white.
This is now all the conditions. any help would be very much appreciated.

Thanks in advance BigH



In conditional formatting:
condition 1 - "formula is" =AND(A1=A2,A3<=A1)...click on Format and format
as desired, click on Add.
condition 2 - "formula is" =AND(A1=A2,A3>A1)....again format as desired.

HTH
JG
 
B

Bob Phillips

use another formula of

=AND(A2<A1,A3=A2)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top