Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying contents of cell on different spreadsheet
I need to set some conditional formatting in cells based on data from different worksheets in the same spreadsheet. When I attempt this, I get an error that conditional formatting can't use data from other worksheets, so I'd like to display the contents of those cells in the other spreadsheet on the spreadsheet that will have the condtional formatting. Example = Cell A1 on spreadsheet A shows the data from cell B2 on Spreadsheet B. Is this a formula I'd use, and, if so, which one? -- telewats ------------------------------------------------------------------------ telewats's Profile: http://www.excelforum.com/member.php...o&userid=30270 View this thread: http://www.excelforum.com/showthread...hreadid=505375 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying contents of cell on different spreadsheet
"telewats" wrote in message ... I need to set some conditional formatting in cells based on data from different worksheets in the same spreadsheet. When I attempt this, I get an error that conditional formatting can't use data from other worksheets, so I'd like to display the contents of those cells in the other spreadsheet on the spreadsheet that will have the condtional formatting. Example = Cell A1 on spreadsheet A shows the data from cell B2 on Spreadsheet B. Is this a formula I'd use, and, if so, which one? When entered in a cell on Sheet 1, this formula will display the contents of cell A1 on Sheet 2. =Sheet2!A1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding the contents of a cell to a formula | Excel Discussion (Misc queries) | |||
How do I display contents of an adjoining cell? | Excel Worksheet Functions | |||
separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
cell contents | Excel Discussion (Misc queries) |