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.