+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting not working

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2013
    Posts
    71

    Conditional Formatting not working

    I need to change cell color based on value compared to adjacent cells. I've tried conditional formatting but it is only changing fill to red and green, nothing is yellow. I'm wondering if it because I'm applying three types of cond formatting to the same range. Also, the report will be run weekly so I'd like it to add a new column at the end since the range is dynamic.

    My parameters and an example are below.
    0% - 5% - Red Fill
    5% - 15% - Yellow Fill
    Over 15% - Green Fill

    Columns F9 - AH161 contains values
    Columns AL9 & AM161 contain goals
    i.e. If any cells
    F9:AH9 < $AL9 = Red
    F9:AH9 > $AL9 and < AM9 = Yellow
    F9:AH9 > $Am9 = Green

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Conditional Formatting not working

    Select F9:AH9

    Conditional Formatting
    New Rule
    Use a formula to determine...
    3 formulas required

    =(F9<AL9)
    format as red

    =(AND(F9>AL9,F9<AM9))
    format as yellow

    =(F9>AM9)
    format as green
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    09-05-2012
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: Conditional Formatting not working

    I actually need a macro, as it is a large table so I would need it to first format F9:AH9, then F10:AH10, and so on to row 162.

    Picture below.
    snap519.jpg

+ 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] Conditional formatting not working?
    By Rheanna in forum Excel General
    Replies: 0
    Last Post: 06-24-2015, 11:49 AM
  2. Conditional Formatting not working
    By Str1der in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-04-2014, 09:08 AM
  3. Conditional formatting not working
    By michmat120 in forum Excel General
    Replies: 3
    Last Post: 12-13-2013, 04:16 PM
  4. [SOLVED] Conditional Formatting not working!
    By mega_nerd in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-13-2013, 02:16 AM
  5. conditional formatting not working
    By arnab0711 in forum Excel General
    Replies: 3
    Last Post: 06-27-2012, 04:55 AM
  6. Conditional Formatting Not Working
    By mycon73 in forum Excel General
    Replies: 14
    Last Post: 07-16-2011, 01:39 PM
  7. Several Conditional Formatting only working on some
    By joblinger in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2009, 05:17 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