can i give a number an automatic colour on spreadsheet

  • Thread starter Thread starter Jann Waterside
  • Start date Start date
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
 
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

linking colour format between sheets 1
Make a Yes/no cell using a single click 6
How to add numbers in a column dependant on their colour 2
Excel 2007 conditional formatting & cell colour. 2
In Excel, can I get a cell to automatically change fill colour de. 1
Automatically fill info from another spreadsheet? 4
Colour Cell based on Content 3
Automatic Numbering 1

Back
Top