Conditional formatting based on cell other than on (2002)

[easson]

Conditional formatting for a cell works on the values or formulas in the cell being formatted. I have a different problem. I want to format a cell based on the value in a *different* cell. For example, if the cell to be formatted conditionally is A2, I want it to be red if cell B3 contains the string "Y". Can this be done without a macro or without programming?

Thanks,

[TonyE]

This can be done with conditional formatting, it can check the value of another cell.

Set up conditonal formatting in cell A2 and use the "Formula is" option. In the formula box enter the following formula:
=B3="Y"

[easson]

Thanks. That worked just fine.