Lets say there are values in cells B1 - B20.
I want the formatting to be in currency format, and if cell A1 equals 1, then formatting of above cells should be euro currency format, and if cell A1 equals 2, formatting should be usd currency format.
What I did and which did not work is: I used conditional formatting and use a formula. I created 2 conditional formatting rule for the same cells depending on the value of cell A1 but it doesnt work. It does it once and it keeps the same last formatting for the rest and it doesnt matter what the value of cell A1 is.
I looked thorugh the previous posts regarding conditional formatting but couldnt find anything similar. Any suggestions?
****I forgot a little detail here. I am using a dropdown box to identify the value of cell A1. Attached is a simple sample.SAMPLE.xlsx
Bookmarks