+ Reply to Thread
Results 1 to 7 of 7

Need help with a conditional formula to highlight cells based on text and numbers

  1. #1
    Registered User
    Join Date
    02-18-2009
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Need help with a conditional formula to highlight cells based on text and numbers

    Hello Excel Experts,

    I have two columns in Excel that I need to compare and highlight text in red if over 100.
    I have text in Column B and number values in Column C. I would like the font in Column C to turn Red if the value (Column C) is > than 100.

    Example:

    Column B:
    Plan 1
    Plan 2
    Plan 3

    Column C:
    90
    200
    150

    So, I would like to create a conditional formula to look at Column B and turn the font Red in Column C if the value is greater than 100. So, in Column C, 200 and 150 will turn Red because their values are greater than 100. I believe from what I researched I need to use the AND function, but I am not formula savvy so I don’t know how to construct the formula.
    Appreciate your help on this one.

    I am using Excel 2010.

    Thank you in advance.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,729

    Re: Need help with a conditional formula to highlight cells based on text and numbers

    why are you looking at column B at all

    just put the formula into column C

    select all column C

    for 2007 or 2010 excel version
    Conditional Formatting

    Highlight applicable range >>

    C:C


    Home Tab >> Styles >> Conditional Formatting
    New Rule >> Use a formula to determine which cells to format
    Edit the Rule Description: Format values where this formula is true:


    =C1>100


    Format… [Number, Font, Border, Fill]
    choose the format you would like to apply when the condition is true
    OK >> OK


    i suspect you want to do something with column B but did not say what
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    02-18-2009
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Need help with a conditional formula to highlight cells based on text and numbers

    Thank you for responding etaf.

    What I am trying to do is look at Plan 1 in Column B and say if Plan 1 in Column B is greater than 100 in Column C, then turn the number value (column C) to red. If the numbers in column C is less than 100, then the numbers will remain black.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,729

    Re: Need help with a conditional formula to highlight cells based on text and numbers

    use

    =AND($B1="plan 1", $C1>100)

  5. #5
    Registered User
    Join Date
    02-18-2009
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Need help with a conditional formula to highlight cells based on text and numbers

    Thank so much etaf, that worked. :-)

  6. #6
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,729

    Re: Need help with a conditional formula to highlight cells based on text and numbers

    your welcome,
    if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

  7. #7
    Registered User
    Join Date
    12-28-2021
    Location
    iraq
    MS-Off Ver
    2007
    Posts
    3

    Re: Need help with a conditional formula to highlight cells based on text and numbers

    Thank you 4 this information

+ 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. Need a 'conditional formatting' formula to highlight cells between dates/text
    By BigSean762 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-29-2014, 02:33 PM
  2. [SOLVED] Conditional formatting formula based on text in two cells
    By lionrookie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2014, 12:50 PM
  3. Replies: 4
    Last Post: 01-03-2013, 12:25 AM
  4. Replies: 5
    Last Post: 09-24-2012, 05:14 PM
  5. Replies: 3
    Last Post: 08-28-2009, 11:16 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