Conditional Formating

[Alex532]

I am trying to use conditional formating so that when dates in tw
different columns are subtracted and result is zero, the a cell i
turned green. However, if nothing is in either cell, or nothing is i
one of the two cells, I need them to remain as the defualt formating.
Does anyone know what formula I need for this?

Thanks,
Ale

 

[Dave Peterson]

Since dates are just numbers to excel, you could count how many numbers are in
the two input cells:

I used A1 and B1 to hold the dates and C1 to hold the formula (with
format|conditional formatting):

formula is:
=AND(COUNT(A1:B1)=2,C1=0)

 

[Cutter]

Using A1 and B1 as your 2 cells to compare:

Use the "Formula is" option for the Conditional Format in whatever cell
you want and type in this formula:

=AND(A1=B1, A1<>"")

 

[Guest]

Put this as the "Formula is" criteria in conditional formatting of cell
C1......change cell references to suit

=AND(COUNT(A1:B1)=2,A1-B1=0)

Vaya con Dios,
Chuck, CABGx3

 

[Alex532]

Excellent, the first response worked perfectly.

Thank You.