+ Reply to Thread
Results 1 to 3 of 3

conditional formatting with icon sets problem

  1. #1
    Registered User
    Join Date
    07-24-2012
    Location
    Maryland
    MS-Off Ver
    Microsoft Office Small Business 2007
    Posts
    9

    Arrow conditional formatting with icon sets problem

    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!!!

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: conditional formatting with icon sets problem

    I suggest you post a file for testing.

    Also, make sure you have at least Service Pack 2 installed. Office 2007 had a lot of bugs when it was first released!
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    07-24-2012
    Location
    Maryland
    MS-Off Ver
    Microsoft Office Small Business 2007
    Posts
    9

    Re: conditional formatting with icon sets problem

    Sorry to be such a rookie, but how do I see if Service Pack 2 was installed?
    Is it a Windows update?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting with icon sets
    By CharN in forum Excel General
    Replies: 1
    Last Post: 12-29-2011, 06:34 AM
  2. Icon sets – conditional formatting
    By pauldaddyadams in forum Excel General
    Replies: 3
    Last Post: 12-02-2011, 06:09 AM
  3. Conditional formatting with icon sets
    By malbar in forum Excel General
    Replies: 6
    Last Post: 11-16-2011, 10:18 AM
  4. Conditional Formatting with Icon Sets
    By MCofman in forum Excel General
    Replies: 1
    Last Post: 05-01-2009, 03:03 PM
  5. Conditional Formatting ICON Sets
    By hozle in forum Excel General
    Replies: 5
    Last Post: 01-14-2009, 12:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1