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

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