Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Conditional Formats Office 2007 And Windows-8

    Hi All,

    I am using Windows-8 now with Office 2007 installed.

    After importing the attached file everything works fine except the Conditional Formats although all criteria are accepted.

    That means no Icons are displayed.

    Thank you very much for your time and help.

    Best regards,

    Wolfgang
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Which cells are an issue? In the Q-L sheet I see icons in the cells of Col E, Col N and Col X [If those are the problem, it may be an XL2007 issue as I am using XL2010]

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts
    Hi Steve,

    thanks for your quick reply.

    Everything ran fine with 2007 and the formulas with the icons were given as an answer by you some months ago.

    Could it be an issue with the color scheme of Windows-8?

  4. #4
    WS Lounge VIP Browni's Avatar
    Join Date
    Dec 2009
    Location
    Rochdale, UK
    Posts
    1,655
    Thanks
    38
    Thanked 161 Times in 139 Posts
    I'm using Windows 8.0 (untouched colour scheme) with Office 2013 and also see the icons like sdckapr does.

    Screenshot attached for illustration...

    Screenshot (107).png

  5. #5
    2 Star Lounger AlanWade's Avatar
    Join Date
    Dec 2009
    Location
    Sweden
    Posts
    109
    Thanks
    12
    Thanked 3 Times in 3 Posts
    On Win 8.1 running Office 2010 I see the icons as well.

  6. #6
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts
    Hi Steve,

    I finally found the root-cause to my problem.

    It is not related to Office 2007 but to the way that my new hardware handles screen resulations.

    If I work in High Resulation Mode all other settings are ignored.

    When I switch to Default Mode everything fine which meansn that I cant't use the full brightness of the availabe color palette.

    Best regards,

    Wolfgang

Posting Permissions

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