Nifty! That looks like it should do it.
However, there's a few issues that arise when I try to do it:
1) Is there a way to evaluate each row individually? Row 2 evaluates
the data in A2, Row 3 in A3, Row 4 in A4, and so on...
2) THe whole row does not get the red background color. Right now, only
a few columns are getting the conditional formatting treatment in that
row.
Thanks for your help in advance! It's much appreciated.
-Will
--
sasquatchbill
------------------------------------------------------------------------
sasquatchbill's Profile:
http://www.excelforum.com/member.php...o&userid=36550
View this thread:
http://www.excelforum.com/showthread...hreadid=565747