You can use FormatConditional Formatting to colour a cell. There are
instructions in Excel's Help, and he

http://www.contextures.com/xlCondFormat01.html

kayleigh wrote:
HOW do i make a box change colour when i type in a word, like yes so it
goes green?????




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html