Friday, February 16, 2018

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