Closed Thread
Results 1 to 5 of 5

Use a formula to determine which cells to format?

  1. #1
    Forum Contributor jonvanwyk's Avatar
    Join Date
    06-28-2010
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2010
    Posts
    452

    Use a formula to determine which cells to format?

    If the number in the cell to the left is larger, then make this cell RED.

    If the number in the cell to the left is smaller, then make this cell GREEN.

    What formula would I use under the conditional formatting tool to make the above two scenarios work? Thanks in advance for your help!

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Use a formula to determine which cells to format?

    After select the cell (e.g. B1)

    enter formula: =A1>B1 and choose RED

    then add new rule with formula =A1<B1 and choose GREEN from Fill tab.

    If you are apply to group of cell horizontal-wise, make sure the formulas don't contain $ signs that would make the references absolute.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    06-04-2012
    Location
    United Kingdom
    MS-Off Ver
    Office 2010
    Posts
    3

    Re: Use a formula to determine which cells to format?

    Hi,

    I've been scratching my head for hours trying to work out what is going wrong.

    I want to format a cell conditional on the value of another cell, as per this thread. No matter what I do, it doesn't seem to work at all. I've made it a simple as possible by creating a new workbook and entering:
    A1: 5
    B1: 2
    C1: Some random text - this cell has the conditional formula: ="A1>B1"

    However, the cell doesn't get formatted.
    Here is a screenshot and here is the simple workbook.

    Any ideas?

    Thanks

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Use a formula to determine which cells to format?

    Please start your own new thread.

  5. #5
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,152

    Re: Use a formula to determine which cells to format?

    Thanks NBVC.

    Magnetar,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed 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