Thread: can you make a formula color a cell rather than display OT?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phazer Phazer is offline
external usenet poster
  
Posts: 2
Default can you make a formula color a cell rather than display OT?
I have a worksheet that someone else made and it has what I think is a
conditional formula
=IF(ISNA(VLOOKUP(B9,patrols1,3,FALSE)),"(OT)",(VLO OKUP(B9,patrols1,3,FALSE)))
can this be made to color the cell rather than display (OT)?
Reply With QuoteReply With Quote