Posted to microsoft.public.excel.worksheet.functions

davisk

external usenet poster

Posts: 14

Highlighting Entire Row using CF

Can I use a conditional format to highlight a entire row, say A1:A20 when
cell value in A21 equals the text "Open" for one color and set another row
color when it the cell value is "Closed"? Much thanks.

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
highlighting entire functions	BorisS	Excel Discussion (Misc queries)	2	June 22nd 06 02:28 AM
Highlighting an entire row using conditional formatting.	SystemHack	Excel Worksheet Functions	5	January 27th 06 01:24 AM
Highlighting entire row cursor on	John	Excel Discussion (Misc queries)	1	January 22nd 06 08:40 PM
Highlighting	Richard	Excel Discussion (Misc queries)	5	November 30th 05 08:03 PM
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck.	Jamie Furlong	Excel Discussion (Misc queries)	6	August 28th 05 09:27 PM

All times are GMT +1. The time now is 06:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us