=IF - conditional formatting
 

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!)

=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!)