CELL COLORS

[PSG]

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.

 

[Barb Reinhardt]

Take a look at Conditional Formats. I'm guessing that should do what you
want.

http://www.mvps.org/dmcritchie/excel/condfmt.htm

 

[Don Guillett]

PLEASE do not type in all caps. Bad netiquette.

 

[Bob Phillips]

Tear the colour palette tool off of the menu and pull it to your working
area.