+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Custom Formula

  1. #1
    Registered User
    Join Date
    03-22-2019
    Location
    Los Angeles
    MS-Off Ver
    2013
    Posts
    34

    Question Conditional Formatting Custom Formula

    Hello,

    I am having some difficulties figuring out a custom conditional formula that changes the cells color depending on two conditions. One of those cells is a drop down list (E Select) and the other contains values that will be compared to values 300 and 500 to determine if it is less than or greater than (green if <= or red if >).

    Condition 1: If twenty_20 is selected check values are <= 300 (make green) or > 300 (make red)
    Condition 2: If twenty3_23/twenty5_25 is selected check values are <= 500 (make green) or > 500 (make red)

    I would like to have a formula for a range of cells, but the formula that I came up with does not work for multiple cells since COUNTIF is counting the total cells that satisfy my condition, rather than looping thru each cell and assigning the correct condition. Not sure how to proceed. The formula is limited and works if a set up conditional formatting for each cell.

    My problem is using the COUNTIF function: AND(ISNUMBER(SEARCH("20",$F$3)), COUNTIF($H3,">300")).

    Thanks in advanced.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Conditional Formatting Custom Formula

    1st, not sure why you are even using countif here. You have a single cell, and countif counts criteria within a range. You would be better served using just H3>300

    2nd, will you only ever have 20, 23 and 25? And why do you need to use text numbering?

    Try this instead...
    =AND(RIGHT($F$3,2)="20",H$3>300)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Help with a Custom Formula Conditional Formatting Rule
    By rtommie84 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-10-2016, 09:17 PM
  2. [SOLVED] Conditional Formatting: Custom Formula
    By sschroe954 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2016, 05:34 PM
  3. Custom formatting issue using conditional formatting
    By wrongway15 in forum Excel General
    Replies: 2
    Last Post: 07-13-2014, 03:18 PM
  4. Conditional Formatting with a custom formula help (Google Docs)
    By joynerCN in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 05-02-2014, 07:53 AM
  5. [SOLVED] Custom conditional formatting
    By prologueden in forum Excel General
    Replies: 3
    Last Post: 05-17-2012, 07:04 AM
  6. Custom Conditional Formatting
    By themachine in forum Excel General
    Replies: 6
    Last Post: 07-20-2010, 10:32 AM
  7. Custom conditional formatting?
    By Pyrex238 in forum Excel General
    Replies: 3
    Last Post: 08-31-2007, 03:02 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