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