Hello,

I'd like some help with a conditional formatting issue.

1. I enter some text e.g. ART in a cell (perhaps A1)

I would like excel to find all the ART cells in a certain range and highlight them (red).

But I would like to be able to change that cell to (GEO) and the excel highlights all the GEO cells in the same range?

Thank you,

mhartle