Thread: IF Formula to produce coloured statements
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
GaryDK[_2_] GaryDK[_2_] is offline
external usenet poster
  
Posts: 10
Default IF Formula to produce coloured statements
Try this, Kylii -

=IF(OR(Data!A1="Overdue",Data!B1="Overdue"),"OVERD UE","OK")

Gary
(less two thru five for direct)

Reply With QuoteReply With Quote