conditional formating

[stathis1234]

Please your help will be appreciated
I dont know if it is possible but I want to highlight (conditional formatting) a column B14:B128 depending on the text values of another column D14:D128 where some criteria met on a specific cell D134 that contains text and is like a dynamic cell i am going to give the text each time to the specific cell.
Thank you

 

[AlphaFrog]

Select B14:B128 and apply this CF formula

=$D14=$D$134

Excel will automatically change the 14 for each row.

 

[stathis1234]

Thank you so much is working fine
But there is a small problem the conditional formating is applying only when is an exact match of the cell d134 to d14
i would like to know if can apply if there is partial matching for example if d14 has a text in it (14.00-23.00 BQT) and D134 has (only BQT) can conditional formating work

 

[Fluff]

Try
=ISNUMBER(SEARCH($D$134,$D14))

 

[stathis1234]

Thank you so much that works fine

 

[Fluff]

Glad we could help & thanks for the feedback