Help Needed!! Date Functions

  • Thread starter Thread starter TBFA
  • Start date Start date
T

TBFA

i have a sheet full of different dates and i need to display if the dat
is / has:

Past
today, or
in the future

just with a colour change or bold text etc.

i've tried a few different ways but i've had no luck, please ca
someone help?

Thanks in advance
 
You could use Conditional formatting.

Select your range of cells with dates.

Then Format|conditional Formatting.

Condition 1:
Cell value is "less than" =today()
(format as required)

Condition 2:
cell value is "equal to" =today()
(format as required)

Condition 3:
cell value is "greater than" =today()
(apply your format)

There's an Add button at the bottom of the dialog that will show the 2nd and 3rd
conditions.
 
In an empty cell, enter "=today()" without quotes. Should give you todays's
date.
Slect the cell tou wish to format. Format>Conditional formatting
Enter the conditions and the formatting required
Post again if you need more details

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Conditional formatting can format for the 3 instances. Format, Conditional
formatting, The cell value is (less than, equal to, greater than), Click on
Format choose a background colour from the patterns tab, click on Add,
repeat twice more.

HTH

Gilles Desjardins
 
Back
Top