Conditional Formatting not updating when using option buttons

cbzdmh

Board Regular
Joined
Jul 16, 2007
Messages
58
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
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

cbzdmh

Board Regular
Joined
Jul 16, 2007
Messages
58
Update - > It works once when I reapply the conditional formatting. Is it a calculation/refresh issue?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,662
Messages
5,573,482
Members
412,533
Latest member
Pejter
Top