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?