HOW do i make a box change colour when i type in a word, like yes so it goes green?????
K kayleigh Sep 26, 2005 #1 HOW do i make a box change colour when i type in a word, like yes so it goes green?????
D Debra Dalgleish Sep 26, 2005 #2 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
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
P papou Sep 26, 2005 #3 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
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