Cells change color when another cell is activated or typed with an
Make sure you have no absolute referencing happening.
i.e. =A1="x"
NOT =$A$1="x"
Gord Dibben MS Excel MVP
On Tue, 14 Jul 2009 12:01:03 -0700, Geauxfish
wrote:
I figured part of this out under conditional formating. I have Excel 2003,
but when I highlight the cells with data I want to turn color, including the
cell I will place an "X" they don't change color. I can only get the cell
that I was in before I performed the "Conditional Formating" to turn color
when I placed an "X" in it. How do I get other cells to change color that
has data.
|