How will the individual cell get the red fill?
If it's through conditional formatting you could extend the conditiona
formatting over the range.
If it's any other way I think you would require VBA code
--
Nori
-----------------------------------------------------------------------
Norie's Profile:
http://www.excelforum.com/member.php...fo&userid=1936
View this thread:
http://www.excelforum.com/showthread.php?threadid=38410