First off...thanks so much for the amazing site. I've got everyone in my company checking out your blog!
Now on to my problem. I'm trying to get a set of cells to change format based on the value in another cell. Pretty simple. Using conditional formatting I can change the color, font, etc., but I can't get it to change the number format from number to percentage. Take a look at the link to a dummy example.
www.apqceducation.org/excel/test.xlsx
Using the scroll bar to move through the records, I want the cell format to change in D8:E15 to percentage when S7 gets to 48 or above and then back again to number format when it goes below 48.
The funny thing is it will work when I apply the conditional formatting when S7 is above 47 and then when I go below 48 it will change to number format, but it will not change it back to a percentage when you go above 47 again. Hope that makes sense.
I must be missing something!!!!
Now on to my problem. I'm trying to get a set of cells to change format based on the value in another cell. Pretty simple. Using conditional formatting I can change the color, font, etc., but I can't get it to change the number format from number to percentage. Take a look at the link to a dummy example.
www.apqceducation.org/excel/test.xlsx
Using the scroll bar to move through the records, I want the cell format to change in D8:E15 to percentage when S7 gets to 48 or above and then back again to number format when it goes below 48.
The funny thing is it will work when I apply the conditional formatting when S7 is above 47 and then when I go below 48 it will change to number format, but it will not change it back to a percentage when you go above 47 again. Hope that makes sense.
I must be missing something!!!!