Thread: Conditional Formatting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
xlbo[_2_] xlbo[_2_] is offline
external usenet poster
  
Posts: 7
Default Conditional Formatting
No real need for cod
Select the range and g
FormatConditional Formattin
Change the left dropdown to "Formula Is" andenter
=FIND("BUSINESS",UPPER(A1)
where the 1st cell in the range is A1
Reply With QuoteReply With Quote