Thread: change text format dependant on formula result
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stu Wilkinson Stu Wilkinson is offline
external usenet poster
  
Posts: 1
Default change text format dependant on formula result
can i test a cell to see if it is one of 2 results using an
=If(a1="","Unsold","sold") formula and then colour it RED dependant on result

eg result is Sold but I want to automatically colour the text RED but if the
result is Unsold leave as black text
Reply With QuoteReply With Quote