ahhh cellref is a specific cell. Sorry. What am I supposed to reference it to
though?


"Gord Dibben" wrote:

First select all the cells to format.

Assuming you changed "cellref" to a real reference like A1

I don't know why your formatting is not working.

Make sure Excel does not add any $ signs to the reference.


Gord

On Wed, 8 Jul 2009 14:41:02 -0700, Deeno
wrote:

Expiration is a year. I tried =cellref<TODAY()-360 and it did not seem to do
anything. I highlighted the applicable cells, went to Conditional
Formating(CF?)New Rule...Use a formula to determine which cells to format
and imputed the formula into the "Format values where this formula is true:"

"Gord Dibben" wrote:

When will the course expire?

Assume 180 days after completion.

FormatCFFormula is =cellref<TODAY()-180


Gord Dibben MS Excel MVP

On Wed, 8 Jul 2009 13:28:00 -0700, Deeno
wrote:

I have a spreadsheet where I have inputed dates (mm/dd/yyyy) when training
classes were completed. I am trying to create some way of notifying user
(conditional formating?) that the course is expired, but cannot seem to get
it to work.

The sheet is set up in this format:

Name Class1 Class2 etc
John Date Date etc
bob date etc etc
etc etc etc etc