can i give a number an automatic colour on spreadsheet

J

Jann Waterside

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
 
B

Bob Bridges

Yes, except you can have only four colors that way (the default color plus
three alternates). If that's enough to satisfy your requirements, Jann, this
is definitely the way to go. If you need more, you'll probably have to
program it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In Excel, can I get a cell to automatically change fill colour de. 1
Criteria - Automatic Change Font or Fill Colour 4
How can I rate a cell 1-5 and colour code it? 2
How do I set up a "Random Number" button in Excel? 1
Automatic Colour Fill In 3
How can I show up and down arrows when a value changes? 1
Removing apostraphes from a group of cells on an Excel spreadsheet 3
can i colour a cell on basis of results of a formula e.g clour bl. 3

Top