Conditionally format only when both criteria are met

Montana

Guest

Posts: n/a

17th Jun 2008

I need cell O12 to change color when cell O17 is greater than zero AND cell
O12 has nothing in it. if either one of these criteria are not met, I want
the cell format to remain as is. Thanks in advance for your help!

« See Changes in Worksheet Submitted Weekly | Counting Unique Pairs of Cells »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditionally format last row of matching criteria	KKD	Microsoft Excel Misc	5	18th Mar 2009 07:10 PM
Format Row Conditionally	FrankM	Microsoft Excel Programming	4	3rd Mar 2009 06:10 PM
conditionally format anumber format	Montana	Microsoft Excel Worksheet Functions	5	15th Jan 2008 05:25 PM
Conditionally open a form based on 3 criteria	=?Utf-8?B?SXZhbiBHcm96bmV5?=	Microsoft Access Form Coding	1	21st Dec 2005 03:48 PM
Conditionally format	=?Utf-8?B?VGVycmk=?=	Microsoft Excel Programming	1	15th Nov 2004 08:06 PM