View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default conditional format for text

You don't need the IF. Try

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

Hope this helps,

hutch

"Todd" wrote:

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.