Apply cell shading based on adjacent cells in EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to change the cell shading based on the value in a cell on
another worksheet of the same workbook.
 
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
 
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.
 
You could also name that cell on the other sheet (Insert|name|define) and use
that in the format|conditional formatting formula.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
SUMIF based on cell shading 1
Conditiona format based on format of another cell 1
Help needed 0
Shade a Cell 7
Conditional Cell Shading (based on the shading of other cells) 2
Shading Rows With IF Statements? 5
Calculating percentage of Shaded Cells in a row 1

Back
Top