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.