| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CELL COLORS
I WANT CELLS TO CHANGE CERTAIN COLORS WHEN I ENTER DATA. IT TAKES TOO MUCH
TIME TO MOVE MY MOUSE TO THE CELL COLOR BUTTON EVERYTIME I CHANGE SOMETHING. IT WOULD BE EASIER WHEN I HAVE TO MAKE MY WORK SCHEDULE FOR 30 PLUS PEOPLE. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CELL COLORS
Take a look at Conditional Formats. I'm guessing that should do what you
want. http://www.mvps.org/dmcritchie/excel/condfmt.htm -- HTH, Barb Reinhardt "PSG" wrote: I WANT CELLS TO CHANGE CERTAIN COLORS WHEN I ENTER DATA. IT TAKES TOO MUCH TIME TO MOVE MY MOUSE TO THE CELL COLOR BUTTON EVERYTIME I CHANGE SOMETHING. IT WOULD BE EASIER WHEN I HAVE TO MAKE MY WORK SCHEDULE FOR 30 PLUS PEOPLE. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CELL COLORS
PLEASE do not type in all caps. Bad netiquette.
-- Don Guillett Microsoft MVP Excel SalesAid Software "PSG" wrote in message ... I WANT CELLS TO CHANGE CERTAIN COLORS WHEN I ENTER DATA. IT TAKES TOO MUCH TIME TO MOVE MY MOUSE TO THE CELL COLOR BUTTON EVERYTIME I CHANGE SOMETHING. IT WOULD BE EASIER WHEN I HAVE TO MAKE MY WORK SCHEDULE FOR 30 PLUS PEOPLE. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CELL COLORS
Tear the colour palette tool off of the menu and pull it to your working
area. -- __________________________________ HTH Bob "PSG" wrote in message ... I WANT CELLS TO CHANGE CERTAIN COLORS WHEN I ENTER DATA. IT TAKES TOO MUCH TIME TO MOVE MY MOUSE TO THE CELL COLOR BUTTON EVERYTIME I CHANGE SOMETHING. IT WOULD BE EASIER WHEN I HAVE TO MAKE MY WORK SCHEDULE FOR 30 PLUS PEOPLE. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
| Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
| Don't print cell colors, Print font colors. | Excel Discussion (Misc queries) | |||
| Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
| Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
Linear Mode
