+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting based on a text and a numeric condition

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Austin,Texas
    MS-Off Ver
    Excel 2011
    Posts
    2

    Conditional formatting based on a text and a numeric condition

    For days I have been beating myself up trying to figure out how to do the following. I have a worksheet that containsdiabetic log information. I want to highlight entire rows where the value in column E=Glucose and also if the value in column H is less than 65 I would like it to display in red text. Any help is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-13-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2003
    Posts
    74

    Re: Conditional formatting based on a text and a numeric condition

    you may try this one. Quite easy
    http://www.homeandlearn.co.uk/excel2...l2007s6p2.html

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Conditional formatting based on a text and a numeric condition

    hello

    in conditional formatting select "Use a formula".
    then

    =AND($E2="Glucose",$H2<65)

    working.xlsx

    edit the coloring.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  4. #4
    Registered User
    Join Date
    08-02-2012
    Location
    Austin,Texas
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: Conditional formatting based on a text and a numeric condition

    Thank you for the suggestions however they do not resolve the problem I need to perform two action based on 2 criteria, I want to highlight entire row where E value is "Glucose" and format values in column H where they are less than 65 and APPEAR ONLY ON GLUCOSE LINES Thanks

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Conditional formatting based on a text and a numeric condition

    working (1).xlsx

    two rule using "Use formula..."


    =$E2="Glucose" for all rows.

    and

    =AND($E2="Glucose",$H2<65) - for column H only

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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