Conditional formatting of Today +21 days?

SHERMAN · #1 12-20-2010, 03:41 AM

I am trying to highlight todays date plus the next 21 days using the conditional formatting. There are a number of preset options, like "last 7 days". Is there a way to make one for "next 21 days".

BjornS · #2 12-20-2010, 04:46 AM

Hi,
Use this conditional formatting:

"Cell value"
"Between"
=today() (start value)
=today()+21 (end value)

Kind regards
Bjorn

SHERMAN · #3 12-20-2010, 05:59 AM

Tks, tried it out. It works great. saved a lot of time.

BjornS · #4 12-20-2010, 08:08 AM

Great that it worked as you wanted!
Please mark the issue as solved.

Kind regards
Bjorn

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
Conditional formatting of cell, Excel 2003	Scaffold	Excel	2	05-01-2010 08:56 AM
Challenge!! Need help though. (Conditional formatting)	knuckles70	Excel	2	02-05-2010 12:24 PM
Conditional Formatting to Hide Rows or Columns?	sczegus	Excel	0	09-26-2006 04:17 PM