You can use Conditional Formatting, however you cant use a direct reference
to another worksheet like Sheet2!A6. You need to name the cell and use that
name in the CF formula,
Regards,
Alan.
"garywr" wrote in message
...
I am trying to change the cell shading based on the value in a cell on
another worksheet of the same workbook.