Hi
I am trying to set a conditional format for the cell is blank or no keywords appeared in the text. I tried different formulas but it didnt work such as IF(S3="",1,IF(COUNT(SEARCH(keywords,S3),0,1),0)).
When I key in the text, for example "No SLA on Friday" or any text which doesn't have the below keywords should show as "1" but it is showing as "0".
My keywords are as follows:
1) No batch
2) No EOD
3) delay
4) activity
5) NA
6) DeCom
Please advise. Really appreciate your assistance.
Regards
Bookmarks