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.