Adding a Background to a date in a field

[ajnw15035]

I manage the use of multiple instances of licences and have recorded each one
on a spreadsheet complete with the last access date. This spreadsheet i
update on a monthly basis and this allows me to monitor if a licences is
being used effectively.
In the first column I have the names of the PCs using the licences. In the
next 12 columns are the last access dates for the various projects.

I would like to set each cell to change it's background depending on the
date entered. E.G. I need the background of the cell to go to red if the date
typed in is greater than three months or 90 days previous to the current date.

 

[Bernard Liengme]

I entered some dates in A1:A30;
With the range selected, I used the command Format | Conditional Formatting
I changed the box from "Cell Value Is" to "Formula Is"
In the formula box I entered =A1-TODAY()>90 (remember to use the = sign
first)
I pressed the Format key on the right side of the Conditional Formatting
dialog and opened the Pattern tab
Here I selected a background colour
By pressing OK buttons I returned to the spreadsheet
All dates 90 ahead of today had coloured backgrounds
May be you want older dates so use =TODAY()-A1>90
best wishes

 

[Mike]

Use conditional formatting.

Cell value - is less than =DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())-90)

Mike.