A few days ago, Dr Phil M posted what appears to be a BUG in the Excel 2007
conditional formatting process. I was hoping an MVP who knew how to report a
BUG would see the thread, but that has not happened yet.

So I repeat it here, in the hopes that this can be fixed.

Apparently, there is an issue with executing a number format conditionally when
the cell being tested has a reference to another worksheet. (The color
formatting of interior works OK; it seems to be only the number formatting that
gets screwed up).

I was able to reproduce this on my Excel 2007.

The original thread is at:
http://groups.google.com/group/micro...310b5f20?hl=en

Here is the portion showing how to reproduce the problem:




You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.


Dr. Phil M
View profile
More options Nov 19, 10:49 pm
Newsgroups: microsoft.public.excel.worksheet.functions
From: Dr. Phil M
Date: Wed, 19 Nov 2008 19:49:00 -0800
Subject: conditional format error Excel 2007

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
--ron