Hi guys,
How do I specify a wildcard whereby if there is mention of the word: close (or closed) in column H, highlight the whole row where close or closed is mentioned, the row should be highlighted in green
thanks,
R.
Hi guys,
How do I specify a wildcard whereby if there is mention of the word: close (or closed) in column H, highlight the whole row where close or closed is mentioned, the row should be highlighted in green
thanks,
R.
Thanks,
R.
=ISNUMBER(SEARCH("Close",$H2))
Quang PT
You can amend your existing CF condition with this formula:
=COUNTIF($H2,"*close*")
Hope this helps.
Pete
thANK YOU VERY MUCH FOR YOUR INPUT GUYS, issue solved :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks