Consitional formatting around today's date

goose74

New Member
Joined
Sep 9, 2002
Messages
1
I'm starting to list all my tasks on an Excel spreadsheet, with Task, Due date, Update and Due date and want to highlight rows as they become due within, say, 2 days of whatever is today's date.

E.g. today's date 10th Sep 02
Task Due
Chase Finance team 15th Sep - no change to row
Chase Marketing 11th Sep - highlight row

I've had a look in Help etc without any luck - how do I do this?

Many thanks
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Steve Hartman

Active Member
Joined
Feb 17, 2002
Messages
417
I do this with a spreadsheet that tracks my testing and reports. I'll send you a copy if you'ld like.
 

WillR

Well-known Member
Joined
Feb 18, 2002
Messages
1,143
On 2002-09-10 08:18, goose74 wrote:
I'm starting to list all my tasks on an Excel spreadsheet, with Task, Due date, Update and Due date and want to highlight rows as they become due within, say, 2 days of whatever is today's date.

E.g. today's date 10th Sep 02
Task Due
Chase Finance team 15th Sep - no change to row
Chase Marketing 11th Sep - highlight row

I've had a look in Help etc without any luck - how do I do this?

Many thanks

Say task in col A, due date in col B, Days to go in col C (formula = B2-TODAY() )
data starts in row 2
......
Highlight whole of row 2
Goto Format, Conditional Formatting
select 'Formula is'
=C$2<2
Select the highlighting you require... ie cell colour yellow
click ok.

Then copy whole row & paste down 'formats' only
 

Russell Hauf

MrExcel MVP
Joined
Feb 10, 2002
Messages
1,611
You can put a formula in conditional formatting similar to this:

=AND(H44>=(DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW()))),H44<=(DATE(YEAR(NOW()+2),MONTH(NOW()+2),DAY(NOW()+2))))

HTH,

rh
 

Forum statistics

Threads
1,144,118
Messages
5,722,587
Members
422,447
Latest member
knopp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top