Can anybody give me a function which fills color in the given range when a particular word appears anywhere inside a cell.
I want to fill with color those cells which contains the word "System". This word appears anywhere in the Text.
Access Control System - Fill color
Fire Alarm System - Fill Color
CCTV System - Fill Color
AC System - Part supply - Fill color