Thread: If, then, else statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default If, then, else statement

Look in the help index for AND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ACarella" wrote in message
...
Two things:
What would the formula be for the following:

If D10<K10 and <0, then L10 (this would put the value in M10)

and

If D10 < K10 and <0, then highlight and bold L10

thank you
Arlene

Reply With QuoteReply With Quote