Id appreciate help understanding why an apparently simple conditional
formatting is not working as expected. A group of rows was formatted at one
time but responded erratically to changes in cell entries. What I did was -
*open a new workbook,
*select rows 1-10
*in the Conditional Format menu, choose €œFormula is€�
*enter =if($A$1=€�€�,TRUE, FALSE)
*choose fill color, for ex. red
*hit the ENTER key
*rows 1-10 turned red, as expected.

Heres the problem. When I typed into cell A1 a few random letters, some of
the rows returned to the default color of white. Why not all? Even more
confusing, if I minimize and expand the window, the formatting of all rows is
now correct.