Two questions:

1. Can I have a conditional format that is dependant on two different
cells? For example in Cell A2 I want to have the cell turn bright red
if A2 is greater than zero and B2 equals zero. I want to then drag
this down for every cell in column A.

2. I cell C2 I want to turn this cell bright red if cell D2 gets the
error message "DIV/0!" to flag there is an error. Is this possible?

Thanks


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=563687