Apply cell shading based on adjacent cells in EXCEL

I am trying to change the cell shading based on the value in a cell on
another worksheet of the same workbook.

Originally Posted by garywr

I am trying to change the cell shading based on the value in a cell on
another worksheet of the same workbook.

Reference the cell in the other worksheet in a new cell in the current worksheet, then use Conditinal Format to check the value in the new cell.
Ilan

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" <garywr@discussions.microsoft.com> wrote in message
news:4B18BAAD-425A-4B89-8775-3E6E7D5B0EEC@microsoft.com...
>I am trying to change the cell shading based on the value in a cell on
> another worksheet of the same workbook.

You could also name that cell on the other sheet (Insert|name|define) and use
that in the format|conditional formatting formula.

garywr wrote:
>
> I am trying to change the cell shading based on the value in a cell on
> another worksheet of the same workbook.

--

Dave Peterson