+ Reply to Thread
Results 1 to 5 of 5

Conditional Formating

  1. #1
    Registered User
    Join Date
    01-02-2013
    Location
    Orem, UT
    MS-Off Ver
    Excel 2010
    Posts
    58

    Conditional Formating

    So If I would like to make a row change colors with conditional formatting based on where a value in a specific cell is <1 or >1 how would I write that out? I want to create 2 different rules. <1 Red >1 Green.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,244

    Re: Conditional Formating

    Assumine that the cell you are testing for ia in column A...

    1. highlight the range you want to apply the conditional formatting to
    2. on the home tabe, styles, select CF
    3. select new rule, select use formula
    4. enter =$A1<1 format fill red

    3. select new rule, select use formula
    4. enter =$A1>1 format fill green

    What color do you want 0 to be? if red, change to <= if green, change to >=
    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

  3. #3
    Registered User
    Join Date
    01-27-2013
    Location
    Greenville, South Carolina
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Conditional Formating

    Dear Sir,
    These conditional formatting functions are a pretty simple matter, BUT you have to be careful about monitoring both the area which is "functioning" and the wording of the function, as changes to the sheet (copying/pasting, etc...) can throw them awry.
    1. Select Conditional Formatting, New Rule, Use formulas to blah blah blah...
    The formatting functions themselves look like this: =IF($G1>1=TRUE,TRUE,"")
    Which means: IF whatever you say is true in the particular cell (i.e. value greater than 1 is true), THEN the format you select becomes true, if false then nothing)
    After you input your formula select format and select whatever you want to happen if your function is true.
    Then go to manage rules and select which cells you would the function to function inside of. ($A$1:$G$5)

    See attached for examples.
    Hope this is clear...
    Conditional Formating Formulas.xlsx

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,244

    Re: Conditional Formating

    @ Ddiehl...using =IF($G1>1=TRUE,TRUE,"") is unnecessary. you can just use =$G1>1...if the result is TRUE, it will apply the format, while, if the result is not true - ie it is FALSE, the formatting will not be applied

  5. #5
    Registered User
    Join Date
    01-27-2013
    Location
    Greenville, South Carolina
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Conditional Formating

    Oh goodness, this will save time LOL

+ 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