I'm trying to format a column of cells based on whether I selected percentage or $ from the drop-down list in the column to the right. Obviously I want the cell to be formated as currency if I selected $ and formatted as a percentage if I selected percentage.
I was able to get this to work initially with two overlapping conditional fomatting rules that used if statements [e.g. if($B1="$")]. However, if I go back to the cell I previously selected as $ and change it to percentage the formatting will not automatically change using the conditional formatting rules. I then have to re-enter the number in the first column to get the conditional formatting to re-run.
Is there another way I can accomplish this?
I was able to get this to work initially with two overlapping conditional fomatting rules that used if statements [e.g. if($B1="$")]. However, if I go back to the cell I previously selected as $ and change it to percentage the formatting will not automatically change using the conditional formatting rules. I then have to re-enter the number in the first column to get the conditional formatting to re-run.
Is there another way I can accomplish this?