Hi all..
i want a cell to change from % format to $ when the value of another cell is 1 or 2!

I do enter formula conditional formatting:
=B6=1 do % formating...

then for the same cell
=b6=2 do $ formatting...

I change the selection but the formatting remains the same!!