Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
Pivottable adding calculated field? | Charts and Charting in Excel | |||
Converting a date field into a month-year only field | Excel Discussion (Misc queries) | |||
Changing a text field to a date field | New Users to Excel | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) |