Hi,
Try using conditional formatting.
Start by selecting your data, then go to FORMAT/CONDITIONAL FORMATTING,
select FORMULA IS and type:
=$E2<$I2
choose your formatting......say red background.
in this example 2 is the first row of data, if different change it.
Hope this helps!
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile:
http://www.excelforum.com/member.php...fo&userid=6261
View this thread:
http://www.excelforum.com/showthread...hreadid=474485