Displaying contents of cell on different spreadsheet

[telewats]

I need to set some conditional formatting in cells based on data fro
different worksheets in the same spreadsheet. When I attempt this,
get an error that conditional formatting can't use data from othe
worksheets, so I'd like to display the contents of those cells in th
other spreadsheet on the spreadsheet that will have the condtiona
formatting. Example = Cell A1 on spreadsheet A shows the data from cel
B2 on Spreadsheet B. Is this a formula I'd use, and, if so, which one

 

[Doug Kanter]

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