change column colour

  1. R

    Change whole row colour according to a true/false formula

    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...

Some videos you may like

This Week's Hot Topics