| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 Conditional Formatting only copies absolute
I'm trying to conditionally format an entire table so that the rows highlight
rew when a date is passed. However, when I copy the format the reference for both column and row remain absolute rather than changing as the row moves up or down. I'm using the formula: =IF(TODAY()=($A436+14)*AND(ISBLANK($F436)),0,1) So that if something is two weeks after the inital date and the cell where a completed should have been entered is blank, then FALSE is returned and the cell will highlight red. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I do conditional formatting for absolute values? | Excel Worksheet Functions | |||
| Conditional formatting in Excel 2007 | New Users to Excel | |||
| Conditional Formatting Excel 2007 | Excel Worksheet Functions | |||
| Conditional Formatting with absolute references | Excel Worksheet Functions | |||
| Excel should let me do absolute copies of cell formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
