Because there are not values that caused the coloring - that was entered by
hand

"EdMac" wrote:


Why not use the value that has caused the other cell to come up red.

So if your conditional formatting for A1 depends on say the content
being greater than 10, then using an if statement in B1 to insert the
value you want =if(A110,Value you want).

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=512291