Hi shadestreet,

Try this,

Conditional formatting for B2
formula is =IF(A20,IF(B2=0,TRUE,FALSE))
select formatting required

Formula in cell C2
=IF(ISERROR(D2),"Error","")

Conditional formatting for C2
formula is =ISERROR(D2)
select formatting required

Is this what you require?

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=563687