+ Reply to Thread
Results 1 to 3 of 3

Incorrect conditional formatting

Hybrid View

  1. #1
    Registered User
    Join Date
    02-24-2017
    Location
    Brussels
    MS-Off Ver
    Office 2010
    Posts
    2

    Incorrect conditional formatting

    Hi folks,

    I'm having some difficulties with conditional formatting of attendance %ages

    The rules I wish to apply are the following:
    > 75% attendance = green
    >=65% & <75% = orange
    >=50% & <65% = red
    <50% = black

    In the attached spreadsheet, I have managed to do this with "format only cells that contain", but I wanted to make use of icon sets which are nicer

    With the icons, 6 of my 18 results are incorrectly formatted and I have no clue why...

    Any suggestion would be highly appreciated!
    Attached Files Attached Files
    Last edited by pderwael; 02-24-2017 at 06:22 AM.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,939

    Re: Incorrect conditional formatting

    in traffic light format
    change the type from Percent to Number and change
    75 as .75
    65 as .65 and
    50 as .50
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    02-24-2017
    Location
    Brussels
    MS-Off Ver
    Office 2010
    Posts
    2

    Re: Incorrect conditional formatting

    Hi,

    Thanks a bunch for this

    I should have thought about this by myself (but I can hardly get a brain transplant...)

    For my education, would you mind explaining why the % were not formatted correcly?

    Thanks again

+ 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. [SOLVED] Highlight week number using Conditional formatting - shows incorrect week
    By spliffter in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 02-26-2016, 09:52 AM
  2. [SOLVED] VBA Formatting Added T Incorrect Column
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2014, 09:50 AM
  3. Incorrect Formula - conditional formatting
    By mahowarth in forum Excel General
    Replies: 4
    Last Post: 09-10-2013, 08:27 PM
  4. conditional formatting displays incorrect value when time is 12:00
    By moonbecky in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2008, 12:44 PM
  5. Conditional format incorrect if not on starting row
    By Kevin Vaughn in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-06-2006, 03:50 PM
  6. Replies: 3
    Last Post: 07-22-2005, 08:05 PM
  7. Incorrect Date formatting
    By dionne_w in forum Excel General
    Replies: 2
    Last Post: 02-22-2005, 06:06 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