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

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

Hello kayleigh
I take it when you write "box" you actually mean "cell"?
If that is so:
Format, conditionnal formatting
Cell value is
equal to
"yes"
Format button
choose relevant colour format (background)
Validate with OK

HTH
Cordially
Pascal

"kayleigh" a écrit dans le message de
news: ...

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


--
kayleigh