Conditional Formatting not updating when using option buttons

[cbzdmh]

Hi,

I have two option buttons labelled as follows: "$ - Dollar Price" & "£ - Sterling Price", these link to Cell A1. Allowing the user to pick how they want to see the prices displayed.

I have a table of prices that links runs a vlookup with an IF statement based on the value in A1, =Vlookup(B1,Data, if($a$1=1, 4,5),false). This functions as expected.

I then have conditional fomating applied to the table as follows:

=$A$1=1 -> $ formatting applied
=$A$1=2 -> £ formatting applied

This works if i change the value in A1 manually but not if I use the option buttons to change the value in A1, does anyone have any ideas?

Many Thanks

 

[cbzdmh]

Update - > It works once when I reapply the conditional formatting. Is it a calculation/refresh issue?