I can get it to work in one direction, but not change the format back to a different format. For example, I can set the rule to change the cell format to percentage if S7>40. If I add another rule that says S7<=40 to change the format to number it will not work. So essentially it will...
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...