PC Review


Reply
Thread Tools Rate Thread

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
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:54 AM.