K
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.
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.