Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to write a wine spreadsheet and would like to have one column
that indicates the year the wine is ready to drink. I have entries about using TODAY() to indicate dates before the current date, however I am struggling to get it to recognise the conditions when the entry in the cell is only the year. Eg. 2005 Can someone please help me with indicating entries where the value (as a year) is less than the current date? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |