yogi_Conditionally Format F3:F If The Hyperlink Contained '/btscontentindex'

Google Spreadsheet   Post  #2373

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-16-2018

question by: Neeve
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/o6X2c3j2SdU;context-place=forum/docs
Conditional formatting

I'd like to create a conditional formatting rule where if any of the cells' formula contain 'bts', they will turn red. Basically the same as 'text contains' but i want it to be able to search the formulas, all of which are hyperlinks.