Thanks. got that done.
Now I need to highlight a cell if it contains a value. So if B1 contains the number "1" (or any number) I want it to show yellow. I also want B12 to show the same colour if there is an entry in B1

How do I do this?