Thread: 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!

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.

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