| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting date
I'm in a spreadsheet with a lot of data and two of my conditional formatting
options are already used, so I only have one left. I would like rows that have a due date of today or earlier to be green but all others stay the way they are (i.e. black). When I enter "formal is = $T1<TODAY()" I get cells that are green even if they are blank. I don't want the blank ones to turn green. Is there some sort of ignore blank statement I can use with it? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting date
=AND(T1<"",T1<TODAY())
works for me! -- Allllen "Derek" wrote: I'm in a spreadsheet with a lot of data and two of my conditional formatting options are already used, so I only have one left. I would like rows that have a due date of today or earlier to be green but all others stay the way they are (i.e. black). When I enter "formal is = $T1<TODAY()" I get cells that are green even if they are blank. I don't want the blank ones to turn green. Is there some sort of ignore blank statement I can use with it? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting date
Worked for me, too!
Thanks :) "Allllen" wrote: =AND(T1<"",T1<TODAY()) works for me! -- Allllen "Derek" wrote: I'm in a spreadsheet with a lot of data and two of my conditional formatting options are already used, so I only have one left. I would like rows that have a due date of today or earlier to be green but all others stay the way they are (i.e. black). When I enter "formal is = $T1<TODAY()" I get cells that are green even if they are blank. I don't want the blank ones to turn green. Is there some sort of ignore blank statement I can use with it? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting date
Conditonal Formatting
Formula IS =AND($A1<=TODAY(),$A1<"") "Derek" wrote: I'm in a spreadsheet with a lot of data and two of my conditional formatting options are already used, so I only have one left. I would like rows that have a due date of today or earlier to be green but all others stay the way they are (i.e. black). When I enter "formal is = $T1<TODAY()" I get cells that are green even if they are blank. I don't want the blank ones to turn green. Is there some sort of ignore blank statement I can use with it? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional Formatting Date | New Users to Excel | |||
| Conditional Formatting | Excel Worksheet Functions | |||
| Conditional formatting of date | Excel Discussion (Misc queries) | |||
| Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Linear Mode
