Conditional formatting using Indirect function
Highlight the entire row which consists of APPLE in column B
For this purpose created a formula using INDIRECT and ROW Functions
Download The Workbook