Thread: Conditional Format question
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Conditional Format question
Cells being in column A use FormatConditional formatting with this formula:
Select column A and enter formula in CF dialog:
=NOT(ISERROR(SEARCH("putasubstringhere",A1)))

Regards,
Stefi

€žst€ ezt Γ*rta:

How can I create a format for the cells which contains a certain substring?
Reply With QuoteReply With Quote