+ Reply to Thread
Results 1 to 3 of 3

Need help with a cell color based off another cells value

  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Need help with a cell color based off another cells value

    Greetings, I am trying to have a cell in a worksheet fill a certain color based on the value of a cell in another worksheet but still in the same workbook.

    Example: If cell A1 (sheet1) equals 1 then cell B1 (sheet2) is green, but if cell A1 (sheet1) equals 2 then cell B1 (sheet2) is yellow and if cell A1 (sheet1) equals 3 then cell B1 (sheet2) is Red

    I have tried the conditional formating yet that seems to only work based on one value unless I am missing something.

    I certainly hope this is possible?? Thank you for taking the time reading!

  2. #2
    Registered User
    Join Date
    06-30-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Need help with a cell color based off another cells value

    In the conditional formatting box there's a button that says ADD, each time you click this you can add additional conditional formatting so the first one will be your reference for 1 and then the next one will be for 2 and so on.

  3. #3
    Registered User
    Join Date
    06-30-2011
    Location
    Minnesota, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need help with a cell color based off another cells value

    Thanks, I have done that but it won't allow me to reference a cell from another worksheet. Any suggestions? I have two sheets, the one worksheet where I want the color to go to is title Store Check Q2.11 and the worksheet that I have the value (either 1, 2, 3) is titles Actions Results

+ 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