Conditional Formatting using cell from another worksheet
 

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.

Conditional Formatting using cell from another worksheet
 

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

Conditional Formatting using cell from another worksheet
 

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