Re: Conditional Formatting in Excel 2003

Claus Busch

Guest

Posts: n/a

3rd Aug 2012

Hi Jade,

Am Fri, 3 Aug 2012 16:06:00 +0000 schrieb Jade Summers:

> Conditional formating
> Green
> =$H10>TODAY()+181

try:
=AND(LEN(H2)>0,H2>TODAY()+181)

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

« Can you print multiple worksheets double sided? | Re: Excel Invoice help »

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
Saving Excel 2007 conditional formatting in Excel 2003 format	fmaccrory@gmail.com	Microsoft Excel Misc	0	28th Mar 2008 07:42 AM
Conditional Formatting - Can I select a select with Conditional Formatting?	Greegan	Microsoft Excel Worksheet Functions	5	31st Oct 2005 03:19 PM
Conditional Formatting that will display conditional data	=?Utf-8?B?QnJhaW5GYXJ0?=	Microsoft Excel Worksheet Functions	1	13th Sep 2005 05:45 PM
Conditional Formatting w/ Conditional Functions... using AND	=?Utf-8?B?S1dHU05B?=	Microsoft Excel Programming	2	16th Mar 2004 07:56 PM
Conditional, Conditional Formatting	John Meyer	Microsoft Excel Discussion	8	21st Dec 2003 09:37 PM