Posted to microsoft.public.excel.misc

external usenet poster

Posts: 460

Conditonal Formatting: Explain This Please

I am trying to repair a command to format conditionally one cell based on the
contents of another cell. Please interpret the following expression.

=IF(AND(COUNT(H150:J150,M150:Y150)=16,COUNTBLANK(K 150:L150)<=1,

DOUG ECKERT

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
conditonal formatting	Lapa	Excel Worksheet Functions	3	February 25th 09 03:05 PM
Conditonal Formatting	EÃ¡n[_2_]	Excel Discussion (Misc queries)	2	September 16th 08 03:15 PM
Conditonal Formatting	TSK	Excel Worksheet Functions	2	May 7th 08 10:33 AM
conditonal formatting in VB	JBW	Excel Worksheet Functions	2	October 12th 07 05:02 PM
Conditonal formatting	Hawksby	Excel Discussion (Misc queries)	2	March 9th 07 01:49 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us