View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Caroline Caroline is offline
external usenet poster
 
Posts: 183
Default comparing one to one cell within range

I am trying to compare each cell to the one below and this for a whole range.
The difficulty comes form the fact that I need to have an alert in one
formula.
Something like
if (A1:A10<B1:B10, "Warning", "")
the warning will appear only if A1<B1 or A2<B2 or A3<B3 and so on.
Any idea?
THanks
--
caroline