Posted to microsoft.public.excel.programming

j.kuhnke

external usenet poster

Posts: 1

coloring a cell only if there is a value entered in it

I need to automatically fill (w/ color) cells, only if a value is entered in
it, otherwise i would like them to stay white. big time saver for the
formatting that i have to do.

aka, when i type in a number, the cell automatically colors. if the number
is 1 i need the cell to be red, if 2 i need the cell to be yellow, if 3 i
need it to be blue.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I restore cell gridlines lost after coloring a cell?	Alan R.	Excel Discussion (Misc queries)	6	January 1st 12 02:13 AM
Cell Coloring	MrMarbles	Excel Discussion (Misc queries)	2	January 13th 10 02:53 PM
Cell coloring	Peter	Excel Discussion (Misc queries)	3	February 8th 09 11:15 PM
Cell Coloring	supersub15	Excel Worksheet Functions	2	October 26th 07 04:12 PM
Coloring Cell Font based on Cell Contents	[email protected]	Excel Programming	3	February 22nd 05 11:37 PM

All times are GMT +1. The time now is 06:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us