Hi all,
I'm trying to simply colour a range of cells when data is entered in to them for example:
When "Dr B" is entered I would like the cell to be automatically coloured green.
I know this can be done using conditional formatting but I have 5 different Dr's to colour in!! is there any way of adding more conditions????? I have had a go at VBA but as I am completely new to it I'm running out of 1) time and 2) patience!
Any help would be gracefully accepted, I wouldn't even say no to a prod in the right direction.
yours hopefully
Alex
x
Bookmarks