+ Reply to Thread
Results 1 to 5 of 5

conditional format query not working as expected

  1. #1
    Registered User
    Join Date
    01-23-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    79

    Post conditional format query not working as expected

    Hello,

    Please see the attached document,

    I cant seem to get the conditional format to work properly. the total and the percentages are to the right.

    Please advise, I thought I was on the right track. Any help will be much appreciated. Thanks in advance
    Attached Files Attached Files
    Last edited by max8719; 12-16-2018 at 07:37 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: conditional format query not working as expected

    Clear as mud. Care to elaborate?

  3. #3
    Registered User
    Join Date
    01-23-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    79

    Re: conditional format query not working as expected

    I currently have theses formats

    =C$4/$AN$3>=$AN$6 red
    =C$4/$AN$3>$AN$3 amber
    =C$4/$AN$3<=$AN$3 green

    but I have notice its not highlighting amber for C4 and green for B10 and B16. either the formula is wrong somewhere, the order or both. Int the case of C4 for example.


    =17/105>=25%
    =17/105>10%
    =17/105<=10%
    Last edited by max8719; 12-16-2018 at 08:05 AM.

  4. #4
    Registered User
    Join Date
    06-21-2017
    Location
    Missouri, USA
    MS-Off Ver
    2007 through 2019
    Posts
    71

    Re: conditional format query not working as expected

    The formatting for all the cells is currently based on row 4. it needs to move when looking at rows 10 or 16. Remove the first $ so it will be =c4......
    One of your 10% formulas says $AN$3 the other says $AN$4. Both should reference $AN$4
    The stop if true box should only be checked for the red.
    Last edited by SjMaxwell; 12-16-2018 at 08:45 AM. Reason: clarity

  5. #5
    Registered User
    Join Date
    01-23-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    79
    That works great thanks.

+ 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. Expected table is not in the expected format - ADODB Connection to Read Only Excel file
    By Roshan10043 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2018, 10:54 AM
  2. Date format not working as expected when extract from text string
    By iantix in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-17-2017, 12:37 PM
  3. [SOLVED] Conditional Format not working as expected
    By scudo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2015, 10:44 AM
  4. [SOLVED] Conditional formatting not working as expected
    By SEMMatt in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-25-2014, 09:53 PM
  5. [SOLVED] FORMAT not working for Date to text as expected
    By JimSnyder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2013, 05:30 PM
  6. [SOLVED] Conditional formating of tab colours not working as expected
    By derekps98 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-02-2013, 04:06 AM
  7. Excel VBA-Date format "mmm" not working as expected
    By sbishops in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2009, 06:40 PM

Tags for this Thread

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