If And Now formatting macros

Thanks Jason that makes sense.

In the first situation, Ultimately it is cell b2 whose color I am ultimately trying to change.

Thanks a lot.
-ritz

It would be set up in pretty much the same way, but it may change, depending on how you loop it for your actual range:

If Range("B2") = Range("C2") And Range("C2") = Range("C1") Then
    Range("B2").Interior.ColorIndex = (whatever)
End If

HTH

Jason

cool. thanks Jason.
I'll give it a shot.

No problem.