HOW do i make a box change colour

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


--
kayleigh

You can use Format>Conditional Formatting to colour a cell. There are
instructions in Excel's Help, and here:

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" <[email protected]> a écrit dans le message de
news: [email protected]...
>
> HOW do i make a box change colour when i type in a word, like yes so it
> goes green?????
>
>
> --
> kayleigh