For conditional formatting, try the following...

Select A4

Format Conditional Formatting Formula Is

Enter the following formula:

=SEARCH("docs/budget",A4)

Choose your formatting

Click Ok

Hope this helps!

In article ,
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.