+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting - changing cell fill colour

  1. #1
    Registered User
    Join Date
    05-05-2017
    Location
    Texas
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    28

    Conditional Formatting - changing cell fill colour

    I need values in a chart to change colour depending on two values that are entered, preferably green and red.

    I need each cell in the chart (light purple) to look at the length value (B3) and compare it to the first value in its row (feet) to see if it is TRUE (=>).
    Then compare the value in the individual cell to the volume value (B5) to see if is TRUE (=>).

    Depending on the results, turn the cell fill colour red (T,F; F,T or F,F) or green (T,T).

    My thought was to use the IS function, but I don't know how to apply it to the whole chart other than doing each cell individually. My actual chart is mmuch bigger.

    excel.jpg

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

    Re: Conditional Formatting - changing cell fill colour

    Select B9

    Conditional Formatting
    New Rule
    Use a formula to determine...

    =AND($B$3=$A9,$B$5=$B9)
    format as green

    =OR($B$3<>$A9,$B$5<>$B9)
    format as red

    Use Format painter (paintbrush icon) to copy to other cells
    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
    05-05-2017
    Location
    Texas
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    28

    Re: Conditional Formatting - changing cell fill colour

    All I get is the entire first row filled with red. All other cells are normal.

  4. #4
    Registered User
    Join Date
    05-05-2017
    Location
    Texas
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    28

    Re: Conditional Formatting - changing cell fill colour

    If I use these rules in this order, they work:
    Format Red
    =$E$3>$B22
    =$E$17>C22:K36
    Format Green
    =$E$3<=$B22
    =$E$17<=C22:K36

    As soon as I add AND or OR, it all falls to pieces.

    Format Red
    =OR($E$3>$B22,$E$17>C22:K36)
    Format Green
    =AND($E$3<=$B22,$E$17<=C22:K36)

    What am I missing?

+ 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. Replies: 3
    Last Post: 03-28-2017, 07:03 AM
  2. Conditional formatting - Fill colour and dates
    By JTBS in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-07-2016, 04:47 AM
  3. Replies: 7
    Last Post: 06-27-2016, 01:11 AM
  4. [SOLVED] Conditional Formatting, problem with cell colour fill based on another cell value
    By first.officer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-18-2013, 08:21 AM
  5. Replies: 1
    Last Post: 09-12-2013, 02:09 PM
  6. Conditional Formatting Fill colour with weekday colour
    By nattasiray in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2008, 06:49 AM
  7. Colour Fill cell range in (Conditional formatting XL2007)
    By airbus319uk in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-27-2007, 06:34 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