Let's say the data in cell A1 is needed in cell D1...

In cell D1 you would type: =A1

Then, with cell D1 still active, click Format Conditional
Formatting...
Set things up as:
Cell Value Is: Greater Than 0

Click "Format" and set up your text color or patterns...

Hope this helps...


--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile: http://www.excelforum.com/member.php...o&userid=30247
View this thread: http://www.excelforum.com/showthread...hreadid=505474