The function you need to look up in excel help is "Conditional formatting".
--
David Biddulph

"Jann Waterside" <Jann wrote in message
...
Putting together a spreadsheet for a guest house and wonder if i can
designate a colour to a number . e.g. if i have two customers in a room
will
the space and number automatically turn yellow on me entering a "2"
Would be grateful for any help. Regards Jann