I am having an unusual problem with conditional formatting using icon sets in Excel 2007. I saw some Q&A with similar probs for Excel 2003 and it just doesn't apply to my situation. I don't even have Excel 2003. I have crappy Vista and Microsoft Office 2007. Anyway, I set up the exact same conditional formatting in a few areas, it all worked fine with no problems at all. I tested it thoroughly and I saved the file as filename.xlsx (which is the standard file extension for excel 2007). I reopened it this morning to print it out and turn it in, and the conditional formatting was all messed up.
As I mentioned, I was using the icon sets. The icons were 5 colored arrows pointing different directions. The conditional formattiong corresponds to numbers 5) A green one pointing up, 4) yellow forward slash, 3) yello pointing sideways, 2) yellow backslash, and 1) red arrow pointing down. When I reopened the file all the arrows are green pointing up, which corresponds to the nunber 5. I looked in the the individual cells and the original numbers ranging from 1 -5 are in there, they don't all contain 5. I tried a manual calculation, entering in new data in blank cells, re-entering data in the original cells, printing, print preview, and saving (not save as)/ re-opening. Nothing worked. Anyone have any idea what is going on? I use conditional formatting all the time, and I have never had this problem. But, I've never used the icons, so it must have something to do with that?
I rehighlighted the affected cells and redid the conditional formatting and it worked. I saved the file, and then also saved it as filename.xlsm (macro enabled excel spreadsheet) and reopened them. That didn't work either. Am I missing something very obvious???? I'm pretty annoyed right now. I spent forever getting this to work right to begin with, since I was unfamiliar with the icon sets.
I do realize that I can write a macro to turn the #s into icons everytime it this file opened, but I can't help but wonder why this is happening in the first place. I want to check if there is a simple solution that i am overlooking in regards to the icon sets conditional formatting. Any help/sugesstions would be appreciated. Thank you!!!
Bookmarks