Conditional Formatting using cell from another worksheet

[David]

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

[David]

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

"davesexcel" wrote:

>
> You could name the range , then in the conditional format enter
> =NamedRange instead of Sheet!range
> Should work
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=573414
>
>