Results 1 to 5 of 5

Conditional formatting not working properly

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2019
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    14

    Conditional formatting not working properly

    I am trying to conditionally format a table in excel but it is not working.

    so the table has a list of 'deliverables on time' in column O and a 'total deliverables' in column Q
    The conditional formatting applies to =$O$14:$O$28 (which is the correct area I want formatted)

    In conditional formatting I have chosen 'format all cells based on their values'
    selected icon sets

    Icon 1 (green dot) 'when value is' (Drop down menu is >=) then in value =$Q$14 (type drop down is Formula)
    Icon 2 (green dot) 'when < formula and' (drop down menu is >) then in value =$Q$14 (type drop down is Formula)
    Icon 3 (red dot) 'when <= formula'

    But all results are presenting with red dots as per icon 3?

    Just for further info my cells read like this

    O14 - 54
    Q14 - 58

    O16 - 11
    Q16 - 11

    O18 - 5
    Q18 - 5

    O20 - 13
    Q20 - 13

    O22 - 7
    O22 - 11

    O24 - 14
    Q24 - 14

    O26 - 0
    Q26 - 0

    O28 - 4
    Q28 - 4

    Where am I going wrong?

    TIA
    Attached Files Attached Files
    Last edited by Bschutz; 04-06-2019 at 11:24 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting not working properly
    By MindControl in forum Office 365
    Replies: 9
    Last Post: 03-12-2019, 04:19 PM
  2. [SOLVED] Conditional Formatting not working properly
    By Bmiha in forum Excel General
    Replies: 3
    Last Post: 07-10-2018, 04:45 AM
  3. Conditional cell formatting not working properly
    By luv2glyd in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-06-2017, 12:49 AM
  4. [SOLVED] Conditional Formatting not working properly
    By Hodge1013 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-23-2015, 07:42 PM
  5. Conditional Formatting Formula Not Working Properly
    By Oscar Martin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2014, 08:59 AM
  6. Conditional formatting not working properly
    By mlucey01 in forum Excel General
    Replies: 4
    Last Post: 01-08-2013, 08:35 PM
  7. [SOLVED] Conditional Formatting using VBA - Code not working properly
    By Tejas.T in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-07-2012, 10:19 AM

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