Conditional Formatting using cell from another worksheet

[Guest]

I have a series of worksheets that refer to a "master" worksheet for
constraints. I want to be able to change the color of a cell on a worksheet
"P1" based on a value in a cell on the "Master" worksheet.
Example:
If !P1J15>='Master'J15 BlueText, otherwise RedText

The Conditional Formatting says I can't use a formula reference to a cell in
another worksheet. Need help.

 

[davesexcel]

You could name the range , then in the conditional format enter
=NamedRange instead of Sheet!range
Should work

 

[Guest]

Well Done! It works.
I named the cell on the Master worksheet and inserted the =rangename and it
worked perfectly. Thank you so much!