I set a conditional format in a cell (A1) using a formula (=B1="") to make
the cell red if cell B1 is blank. I then used the Format Painter to copy
this conditional format to other cells - say A2 thru A100. If I look at the
conditional format in cell A47, why does it tell me that this conditional
format formula is =B2="", and that it "Applies to $A$2:$A$100"?

I liking Excel 2007 less and less each day.

--
Bill @ UAMS