+ Reply to Thread
Results 1 to 3 of 3

How to use conditional formatting with logical operators present in the excel sheet

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to use conditional formatting with logical operators present in the excel sheet

    Hello,

    I am not able to use conditional formatting when the condition cell contains ">=" operators.

    The sheet has a target column (col A) which has value >=10%
    If achievement column (col B) has values:-
    <10% it should highlight in Red (e.g.: -10%, 0%, 5%)
    if >=10% it should highlight in Green (e.g.: 10%, 20%)

    Conditional formatting works on the achievement column when I input 10% in the target column but does not work when i input target as >=10%

    I have attached sample excel sheet for your reference, please see Row 6.

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: How to use conditional formatting with logical operators present in the excel sheet

    hi excelunaware, welcome to the forum. yes you cannot refer to a cell with operators inside. unless you are working with COUNTIF, SUMIF or AVERAGEIF. so here's 1 way:
    select the range you want to apply to (i.e. from B6:F6)
    go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
    =COUNTIF(B6:B6,$A6)

    format as green

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    05-13-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to use conditional formatting with logical operators present in the excel sheet

    Hi benishiryo,

    Thank you for the quick reply.

    I applied the formula as you suggested and it worked, the values >=10% were highlighted in Green.
    Is there a way to do the same where <10% is highlighted in Red?

    Thanks

+ 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