View Single Post
  #4   Report Post  
pinmaster
 
Posts: n/a
Default


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