| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weeknum vs Conditional Formatting
Excel2003 ... Weeknum vs Conditional Formatting???
Cell E1 ... =IF(ISBLANK($D1),"",D1+7) ... Return = 01/14/07 ... ok Cell E3 ... Conditional Format Formula ... Format Pattern Gold ... not working??? =weeknum(today(),2)<weeknum(e$1,2) ... Returns error message = "You may not use references to other worksheets or workbooks for Conditional Formatting criteria." I am stuck ... Help! ... Thanks ... Kha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting using Formulas and WEEKNUM | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| weeknum formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
