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.

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.

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.

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.