+ Reply to Thread
Results 1 to 4 of 4

Using a formula to determine which cells to format rule type in conditional formatting

  1. #1
    Registered User
    Join Date
    08-03-2012
    Location
    na
    MS-Off Ver
    Excel 2010
    Posts
    12

    Using a formula to determine which cells to format rule type in conditional formatting

    Hello,
    Can someone help me with the following question. I am using conditional formatting(the highlight cells rules) and I have to select "manage rules" and then select "a formula to determine which cells to format". So I am having trouble with typing in the right formula. The two columns I am trying to type a formula for are "asking price" (B2:B118) and "Sale price" (F2:F118) I want the cells highlighted in green in the "Sale price" column that are higher than the asking price. Can someone please tell me what formula to type in that will highlight these cells in the "Sale price" column? Any help would be greatly appreciated.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,309

    Re: Using a formula to determine which cells to format rule type in conditional formatting

    Select F2 to F118. Then click on Conditional Formatting, Manage Rules, and Formula to determine which cells to format. The formula is: =$F2>$B2 and format green.

    The formula will automatically adjust for all the rows.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    08-03-2012
    Location
    na
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Using a formula to determine which cells to format rule type in conditional formatting

    @ TMS Thank you so much this worked perfect!!!

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Using a formula to determine which cells to format rule type in conditional formatting

    If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.

    New quick method:
    Select Thread Tools (above first post on page) -> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word "Title" you will see a dropdown with the words "No prefix".
    Change to "Solved"
    Click Save

    Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,309

    Re: Using a formula to determine which cells to format rule type in conditional formatting

    You're welcome. Thanks for the rep.

    Please mark your thread as solved.

    Regards, TMS

+ 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