I've tried using Conditional Formatting but it only changes one cell.
I want to type in a trigger word into cell which when entered will change that column or a selection of cells in that column to a particular colour (grey).
(It's for doing staff work rota's and I want to type in 'OFF', that...