Conditional Formatting on Different Sheets

[George Bundy]

How do I use conditional formatting based on a cell
reference on a different worksheet. Each time I try it, I
get an error message saying that this cannot be done!

Thanks,
George

 

[Debra Dalgleish]

You can refer to a named cell on another sheet, e.g.: =CheckCell>50

Or, use an Indirect formula, e.g.: =INDIRECT("Sheet2!B3")>50
or: =INDIRECT("Sheet2!"&CELL("address",B3))>50

 

[JE McGimpsey]

name the cell reference and use the name in the CF.

 

[Guest]

My guess would be to merge the worksheets, then try it.

D