TODAY() Function

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Good Morning All,

Using Windows XP and Excel XP.

In Column A I have a weekly start date and in column B I have an weekly end
date with other data in columns C to Z.
I want to highlight the two columns when today's date falls within the
weekly date range. I know that the =TODAY() function will only highlight
today's date. How can I write the formula in the condtional format to
highlight the weekly range when a the date falls within that range.

Example:


A B
-----------------------------------------------
1 Jan 1 Jan 7
2 Jan 8 Jan 14
3 Jan 15 Jan 21
4 Jan 22 Jan 28
5 Jan 29 Feb 4
6 Feb 5 Feb 11
7 Feb 12 Feb 18
etc.........

How can I write the conditional format formula that will highlight columns
A6:B6 with todays date (Feb 6)


Thank you in advance,

Michael
 
Try the following...

1) Select your data, for example A1:B7

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:

=(today()>=$A1)*(today()<=$B1)

4) Choose your formatting

5) Click OK

Hope this helps!
 
Hi

select both columns
choose format / conditional formatting
choose formula is
and type
=AND($A3<=TODAY(),$B3>=TODAY())

click the format button set your formatting and click ok twice

Cheers
JulieD
 
One way:

Select A6:B6 and enter


CF1: Formula Is =AND($A1<=TODAY(),$B1>=TODAY())
 
Back
Top