Hello Bill,

Pl. read this with an open mind...

What you have really done is use the formula =B1="" and then painted it to
apply to $A$2:$A$100, right?

That is exactly what Excel 2007 is telling you ... that the formula is
(=B2="") and the range it is applied to is $A$2:$A$100. You know and I know
that Excel applies the relative formula by changing the row number
appropriately... Won't you get confused if it showed the formula (=B47=""
)for the current row and still showed the range as $A$2:$A$100?

btw can you think of any other way to convey the information if you want to
show the range the formula is applied to?

Also how is it worse than Excel 2003 where you had to go each cell to see
what the conditional formatting was for each cell (though it showed you the
current row reference)?

If you go back to A1 it will show you =B1="" and say it applies to the
range A1:A1

Pl. don't shoot me if you don't like the message :-)

"BillCPA" wrote:

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