Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set a colour to 4 cells based on the value of a cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
how to color code a row of cells based on a specific cell value | New Users to Excel | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions |