Apply cell shading based on adjacent cells in EXCEL

G

garywr

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

ilanr01

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

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
 
A

Alan

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.
 
D

Dave Peterson

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