I have a dashboard report I'm developing that will allow a user to select from a drop-down list (validation list) the type of report they would like to view. Based on the type of report they choose, I've used conditional formatting to format the cells. For instance, one cell, let's say cell A2, may need to be formatted as currency for the first report type and as a percentage for another.

I've used the following three formulas in separate conditional formatting rules in the same cell to change the format of the cell based on the value in the validation list.

=MATCH($B$2,Result_List,0)=1 - then the format would be currency
=MATCH($B$2,Result_List,0)=2 - then the format would be a percentage
=MATCH($B$2,Result_List,0)=3 - then the format would be currency

The issue is, when I change the drop down, sometimes the format in the cell changes and sometimes it does not. I think it has something to do with the order, but am unable to determine the cause...