View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default Working with times

In this set up you can add a formula in cell D3 as follows:

=IF(B3="","",IF(B3<C2,"ERROR",""))

and copy it into D4 (and downwards). I have assumed you have a row of
headings, so you actually want to check from the second entry onwards.

Hope this helps.

Pete