Posted to microsoft.public.excel.misc

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

Conditional Formatting in Excel 2003

Hi Jade,

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

Conditional formating
Green
=$H10TODAY()+181

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

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

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
EXCEL 2003 - Conditional Formatting	Peterepeat	Excel Discussion (Misc queries)	2	January 14th 10 04:44 PM
Conditional formatting excel 2003	Kostas	Excel Discussion (Misc queries)	2	April 2nd 09 12:11 PM
Excel 2003 with 6 Conditional Formatting	Brian	Excel Programming	2	March 30th 09 06:31 AM
Conditional Formatting - Excel 2003	Dan	Excel Discussion (Misc queries)	3	September 9th 08 04:43 PM
Excel 2003: Conditional Formatting	oceanmist	Excel Discussion (Misc queries)	3	September 20th 06 10:55 PM

All times are GMT +1. The time now is 12:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us