Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 38

Conditional Formating

I have data in multipal rows and one column is for date. If date column is
blank I would like to highlight rest of the row in color.

A B C D E F
21 32 12 54 12 OCT 12, 2009
23 43 12 11 34

As F2 is blank I would like to highlight row 2 to be yellow. This should
happen only once I start placing the data in this row.

Thanks in advance for your help.
Kimti

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
Conditional Formating	Allan	Excel Discussion (Misc queries)	2	January 29th 09 02:18 AM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
Conditional formating	Vinay G	New Users to Excel	1	July 19th 05 10:03 AM
conditional formating....	doran_doran	Excel Worksheet Functions	2	July 16th 05 08:52 AM
Conditional Formating	mike lowry	Excel Worksheet Functions	6	February 9th 05 11:41 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us