Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i give a number an automatic colour on spreadsheet
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i give a number an automatic colour on spreadsheet
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can i give a number an automatic colour on spreadsheet
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. --- "David Biddulph" wrote: The function you need to look up in excel help is "Conditional formatting". --- "Jann Waterside" <Jann 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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Colour Control | Excel Worksheet Functions | |||
To give back ground colour for entire row on certain condition | Excel Discussion (Misc queries) | |||
How to create an automatic generated number for a spreadsheet | Excel Discussion (Misc queries) | |||
how to give an automatic number | Excel Worksheet Functions | |||
Automatic Colour Fills | Excel Discussion (Misc queries) |