Is there a way to use conditional formatting in a cell, but based on a condition from another cell.
ie. If Cell A1 = X Then if B1 = 2, I want the background colour of B1 to be Blue, but if the cell A1 = Y and B1 = 2 I want the background colour of B2 to be Red.
Its probably either not possible or a very simple solution. Im pretty much a novice when it comes to excel programming
Thank you