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?????
|
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 |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com