Posted to microsoft.public.excel.worksheet.functions

Karenobrn

external usenet poster

Posts: 2

coloring a cell if blank

I would like to format a column so that if no data has been entered in a cell
in that column then the cell would be colored or marked somehow. Is this
possible? I have tried Conditional Formatting but it only colors the cell if
there is data in that cell... I want to do the opposite.

Thanks
Karen

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
Cell coloring according to the other cell's value	Sore	Excel Worksheet Functions	2	January 25th 08 05:24 PM
Cell Coloring	supersub15	Excel Worksheet Functions	2	October 26th 07 04:12 PM
conditional cell coloring	phrodude	Excel Worksheet Functions	5	July 28th 06 12:15 AM
Coloring Active Cell	Carroll	Excel Worksheet Functions	8	September 30th 05 12:45 PM
Automatic coloring of blank cells when sheet work complete	bigdaddy3	Excel Worksheet Functions	14	August 5th 05 05:00 PM

All times are GMT +1. The time now is 02:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us