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!