conditional format for text

T

Todd

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.
 
M

MDubbelboer

looks fine, make sure you have the true,false part at the end or else
it'll say you've entered too few arguments
 
T

Tom Hutchins

You don't need the IF. Try

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

Hope this helps,

hutch
 
D

Domenic

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!
 
Top