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