View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default =IF - conditional formatting

=B1<A1

assuming delivered in A1, invoices in B1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mel" wrote in message
...
I have 2 figures - One is for delivered the other is for the number of
invoices raised against delivered. What formula can I use so that if the
invoices raised is less than than that delivered the result is shown in

red
for example. (I know how to do the conditional formatting part - just

can't
get the sum right!)