View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Todd Todd is offline
external usenet poster
 
Posts: 177
Default conditional format for text

I am trying to write a conditional format to check a line of text. I have

=IF(COUNTIF(A4,"*docs\budget*")<1)

to check if the words docs\budget are in a line of text and this is not
working.

Here is an example of the text.
Y:\auto\224\712\5225\01\docs\budget

Where did I go wrong?

Thanks.