R
Ron Rosenfeld
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/micr...s/browse_thread/thread/46c6398f310b5f20?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 <[email protected]>
Date: Wed, 19 Nov 2008 19:49:00 -0800
Subject: Re: 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
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/micr...s/browse_thread/thread/46c6398f310b5f20?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 <[email protected]>
Date: Wed, 19 Nov 2008 19:49:00 -0800
Subject: Re: 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