| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use the date in conditiional formating?
I want anything past todays date to highlight in red. How do I do that? (can I do that?) -- gargoyle ------------------------------------------------------------------------ gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121 View this thread: http://www.excelforum.com/showthread...hreadid=568535 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use the date in conditiional formating?
Change the condition to Formula Is and add a formula of
=A1<TODAY() then format, assuming that A1 is the target cell. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "gargoyle" wrote in message ... I want anything past todays date to highlight in red. How do I do that? (can I do that?) -- gargoyle ------------------------------------------------------------------------ gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121 View this thread: http://www.excelforum.com/showthread...hreadid=568535 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use the date in conditiional formating?
Select a range of cells to format, say A1:A100
FormatConditional FormattingCell Value is: greater than =TODAY() and hit OK Watch out for that one. Excel will turn it into ="TODAY()" Pick again and edit out the " marks Format to Red from FormatPatterns. OR............................ FormatConditional FormattingFormula is: =$A1TODAY() Both the same but I prefer the Formula is in most cases. There are so many more options when using the Formula is: Gord Dibben MS Excel MVP On Fri, 4 Aug 2006 18:26:03 -0400, gargoyle wrote: I want anything past todays date to highlight in red. How do I do that? (can I do that?) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use the date in conditiional formating?
I always think of "past" today as after today but maybe OP wants "past" dates
which would be before today. Maybe we'll find out.<g Hope so. Gord On Sat, 5 Aug 2006 00:04:10 +0100, "Bob Phillips" wrote: Change the condition to Formula Is and add a formula of =A1<TODAY() then format, assuming that A1 is the target cell. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "gargoyle" wrote in message ... I want anything past todays date to highlight in red. How do I do that? (can I do that?) -- gargoyle ------------------------------------------------------------------------ gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121 View this thread: http://www.excelforum.com/showthread...hreadid=568535 Gord Dibben MS Excel MVP |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use the date in conditiional formating?
Went with 'less than' as I wanted everything that was 'past-due' to show up in red. Thanks everyone. -- gargoyle ------------------------------------------------------------------------ gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121 View this thread: http://www.excelforum.com/showthread...hreadid=568535 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I use the date in conditiional formating?
Thanks for clearing that up.
Another one for Bob<g Gord On Sun, 6 Aug 2006 06:19:35 -0400, gargoyle wrote: Went with 'less than' as I wanted everything that was 'past-due' to show up in red. Thanks everyone. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| Another Date issue. | Excel Worksheet Functions | |||
| Help with date formating when export to Word | Excel Discussion (Misc queries) | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Linear Mode
