| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting of date-cell - 2007
I would like to conditional format cells - in colors - containing a date if
date in cell is before or after TODAY(). This is not - strangely - an option in the general Highlight date occurring... CF of Excel2007. How do I do this, then? I have tried greater/less than but it did not work. Additional question: I tried one of the possible options (Yesterday) this worked with date format dd-MM-yy but when I changed format to yy-MM-dd (which I would like to use) it did not work. How come? Any help appreciated! -- Best regards Ulf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Excel 2007: cell shading (not conditional formatting) | Excel Discussion (Misc queries) | |||
| conditional formatting date and blank cell | Excel Discussion (Misc queries) | |||
| Excel 2007 conditional formatting & cell colour. | Excel Worksheet Functions | |||
| Apply conditional formatting to individual cell Excel 2007 | Excel Worksheet Functions | |||
Threaded Mode
