Excel 2007 Bug? Conditional Formatting

[kzjkd6]

My client has the following situation:

Sheet1
A1 = 5%
A2 = $3.00
A3 = (a list option to determine if they want to use the % or the $)

On Sheet2 the formulas use the value of A3 in an if condition to apply
either A1 or A2 to calcuations.

This all works fine.

On Sheet2 they have a cell that simply reports the A1 or A2 value
being used in the calculations. The conditional formatting I wrote
compares the value in that cell to the original A1/A2 cells and sets
the formatting to either currency or % as appropriate.

At first blush it seems to work but as I change the selected item in
A3 and flip back to the second sheet I see the value in the cell has
changed but the formatting has not. If I go in to the Conditional
Formatting dialogue, edit nothing, and exit, the formatting is now
correct. Pressing F9 has no affect. I can't seem to get Excel to
refresh this formatting. Scrolling away and back doesn't work, nor
does flipping back and forth between sheets.

I've already implemented a VBA work around to this but I would love to
get this resolved without having to change the file type to a macro-
enabled variety.

Thanks in advance.

 

[Roger Govier]

Hi

I have had problems and reported a bug with Conditional Formatting, when
using % which are less than 0.
Maybe you are experiencing something similar.
The way I got round it until a fix, is to use Number rather than percentage.
Maybe if you use .05 rather than 5% in your CF test.