Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2010, 03:41 AM
SHERMAN's Avatar
SHERMAN SHERMAN is offline Conditional formatting of Today +21 days? Windows 7 32bit Conditional formatting of Today +21 days? Office 2007
Novice
Conditional formatting of Today +21 days?
 
Join Date: Dec 2010
Location: Denmark
Posts: 2
SHERMAN is on a distinguished road
Default Conditional formatting of Today +21 days?

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".
Reply With Quote
  #2  
Old 12-20-2010, 04:46 AM
BjornS BjornS is offline Conditional formatting of Today +21 days? Windows Vista Conditional formatting of Today +21 days? Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
Use this conditional formatting:

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

Kind regards
Bjorn
Reply With Quote
  #3  
Old 12-20-2010, 05:59 AM
SHERMAN's Avatar
SHERMAN SHERMAN is offline Conditional formatting of Today +21 days? Windows 7 32bit Conditional formatting of Today +21 days? Office 2007
Novice
Conditional formatting of Today +21 days?
 
Join Date: Dec 2010
Location: Denmark
Posts: 2
SHERMAN is on a distinguished road
Default

Tks, tried it out. It works great. saved a lot of time.
Reply With Quote
  #4  
Old 12-20-2010, 08:08 AM
BjornS BjornS is offline Conditional formatting of Today +21 days? Windows Vista Conditional formatting of Today +21 days? Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

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

Kind regards
Bjorn
Reply With Quote
Reply

Thread Tools
Display Modes


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 Today +21 days? 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft