| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional indirect with data range
I am trying to set up a conditional formula to look at a value in row "K"
then highlight the entire row. The catch is that I want it to highlight in red if the value is between "1 years, 0 months, 0 days" and "2 years, 0 months, 0 days" and I want it to be bold red if the value is greater than "2 years, 0 months, 0 days" My current formula is =INDIRECT("K"&ROW())"1 years, 0 months, 0 days" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Conditional or Indirect fill up | Excel Discussion (Misc queries) | |||
| INDIRECT for range of sheets | Excel Worksheet Functions | |||
| Indirect Range | Excel Worksheet Functions | |||
| Conditional data validation (using a filtered range?) | Excel Worksheet Functions | |||
Threaded Mode
