| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format with error & date check
I want a column to have any cells with #NA turn red if the today's date is
after a certain date. I'm sure I could use a specific cell reference such as a2,a3,etc. and copy/pase special a formula down the rest of the column but I'm wondering if there was a way to select the column and set a single formula to do the job. Below is a couple examples that failed. ="and(iserror{at:at},today()<date(2008,1,1))" ="and(iserror(at:at),today()<date(2008,1,1))" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format error Excel 2007 | Excel Worksheet Functions | |||
| Date format error | Excel Discussion (Misc queries) | |||
| Date-error Format | Setting up and Configuration of Excel | |||
| RANDBETWEEN in a conditional format gives error | Excel Worksheet Functions | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Threaded Mode
