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.

garywr Wrote:
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


--
ilanr01
------------------------------------------------------------------------
ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797
View this thread: http://www.excelforum.com/showthread...hreadid=466472

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.

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