Conditional formatting cells by date

Lewis

Board Regular
Joined
Feb 16, 2002
Messages
50
I am trying to set a sheet in which some cells have dates entered. I want the background colour to change when todays date is 30 days or less than the date in the cell and another colour when todays date is after the date in the cell. I am assuming htis could be done by conditional formatting.

Is it possible to make the cell flash if todays date is after the date in the cell?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

maxflia10

Well-known Member
Joined
May 20, 2002
Messages
890
Try
=today()-a1<=30 and
=today()>a1

The "flashing" part needs VBA
This message was edited by maxflia10 on 2002-10-16 23:42
 

rmtaylor

Board Regular
Joined
Feb 17, 2002
Messages
155
SELECT FORMAT, CONDITIONAL FORMATTING
Select CELL TO RECEIVE CONDITION
Click on Format, and use a "Formula Is" condition.
Example
If cell A5 has today() (formula to specify show today's date )
and say cell B5 is where the +30 day condition will apply
the formula is conditionwould be =$B5>$A5+30

NB both rows must be formated to the Date Format

To Copy the formatting down select the row where the condition is applies say
click on copy .
Select area where the formatting is to be copied to,
Click on EDIT, PASTE SPECIAL then select FORMATTING.

The conditional formatting will be active in this array of cells

A TYPICAL EXAMPLE HOW TO NEST FORMULA USING AN OR, AND STATEMENT TO ACHIEVE MORE CONDITIONS
Highlight cells to be affected by conditions the enter as below

=OR($B3="PASS",$B3="ABORT")
=AND($B3<3,$E3="FAIL)"
=$E3="FAIL"
AND SO ON
 

Forum statistics

Threads
1,144,275
Messages
5,723,449
Members
422,497
Latest member
dougy99

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