I have a table with a column B6 - B24. This contains company names.
Another column G6 - G24 with notes.
I would like a formula that would highlight a company name(column B) if the text "call off" is written in notes.
Also these columns might grow so would there be a way of having a formula that applied to the entire column?
Any help would be greatly appreciated.