On Wed, 19 Nov 2008 19:49:00 -0800, Dr. Phil M
wrote:

Ron thanks! I'm using Ecel 2007.
The SS is a little complex but I made up a simple one which shows the error.
As below
Sheet 1 data entry in A1 and B1
Sheet 2
A1 =Sheet1!A1
A2=Sheet1!A2
A3=SUM(A1:A2)
Format sheet 2 A3 as a number with 1decimal place
Conditional format sheet 2 A3 with say 6 decimal places with condition
formula =$A$1=0
So if you enter 0 in sheet 1 A1 then see 6 decimal places in sheet 2 A3.
if you then enter 1 in sheet 1 A1, Excel does not reset sheet 2 A3 to 1
decimal place until you delete a blank cell on sheet 2.
Wierd?
Thanks
Phil

I can reproduce it now, and yes, it is extremely weird.

With regard to the conditional formatting, it seems to only affect the number
format. If, in addition to formatting the 6-decimal places in the conditional
format dialog box, you also format a fill color (for the same condition), the
fill color changes appropriately when the number format behaves as you
describe.

As you wrote, it is only an issue if the precedent cell refers to another
worksheet.

To me, all this implies that the Conditional Formatting is being triggered, but
there is some issue with the number formatting "going along".

I believe the ability to include number formatting in with the conditional
formatting was new in Excel 2007.

Seems to me to be a real bug.

Hopefully, one of the MVP's who has a contact with Microsoft for reporting bugs
will see this thread. If not, we should repost it.
--ron