Conditional formatting of Today +21 days?

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formatting of Today +21 days?

12-20-2010, 04:46 AM

BjornS

Windows Vista Conditional formatting of Today +21 days?

Office 2003

Competent Performer

Join Date: Jan 2010

Location: Sweden

Posts: 116

Hi,

Use this conditional formatting:

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

Kind regards
Bjorn

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:14 AM.