LinkBack URL
About LinkBacks
Here's my formula: =COUNTIF(G2:G3366, "*client*" & "*name*")
Is there a way to add conditional formatting to this. For example to say, in all cells G2 thru G3366, where there is text "client" and "name", fill the cell color as blue?
Here's my formula: =COUNTIF(G2:G3366, "*client*" & "*name*")
Is there a way to add conditional formatting to this. For example to say, in all cells G2 thru G3366, where there is text "client" and "name", fill the cell color as blue?
USe CF rule
=ISNUMBER(MATCH("*client*" & "*name*",G2,0)) --- format blue
Life's a spreadsheet, Excel!
Say thanks, Click *
You could use the COUNTIF in CF, e.g.
=COUNTIF(G2,"*client*name*")
or this one....
=SEARCH("client*name",G2)
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks