I'm having a senior moment here and can't remember how to colour a cell automatically depending on the text in that cell. I'm creating a holiday sheet and want to see easily who's off and when by the colour of the cell after I've put their name in the cell. Any help appreciated thanks