+ Reply to Thread
Results 1 to 4 of 4

Using conditional formatting to fill a cell colour based upon 1 of 2 conditions

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Leicester,England
    MS-Off Ver
    Excel 2007
    Posts
    23

    Using conditional formatting to fill a cell colour based upon 1 of 2 conditions

    I want the result of a formula in cell A7 to change colour using a formula whereby if A7 is greater than the number held in A3+30% then its one colour but if it's greater by 50% or more it's a different colour. I've tried different possibilities using conditional formatting to no avail.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Using conditional formatting to fill a cell colour based upon 1 of 2 conditions

    Use two rules in conditional formatting. I tend to use formulas but you could use "Format only cells that contain" If using formulas:

    =A7>1.5*A3

    =A7>1.3*A3

    Put the rules in the order shown above.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    08-21-2012
    Location
    Leicester,England
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Using conditional formatting to fill a cell colour based upon 1 of 2 conditions

    Many thanks my problem was I omitted to put the rules in the correct order

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Using conditional formatting to fill a cell colour based upon 1 of 2 conditions

    You're welcome. Excel CF rules are executed in the order provided and if more than one rule applies, the last one is the winner. It is possible to write the rules to be mutually exclusive, though.

    =A7>1.5*A3

    =AND(A7>1.3*A3,A7<=1.5*A3)

    Then the order doesn't matter.

+ 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. Conditional Formatting - changing cell fill colour
    By Chamuit in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-05-2017, 03:03 PM
  2. conditional formatting fill cells based on text, how to find sum based on CF colour
    By tubbybear in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-27-2016, 12:04 PM
  3. Replies: 6
    Last Post: 04-11-2016, 09:48 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. VBA for Conditional Formatting - apply a colour based on conditions in each column.
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2013, 01:24 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