| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cond. Formating
I would like to format dates prior to "today" in red. I have 2007.
My guess is I should use a formula when selecting a rule type, but <today() doesn't seem to work. Any ideas? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cond. Formating
Not sure how the dialog box looks in 2007, but in 2003, simply select
Cell Value Is, Less Than, and =Today() in the fields. Caroline wrote: I would like to format dates prior to "today" in red. I have 2007. My guess is I should use a formula when selecting a rule type, but <today() doesn't seem to work. Any ideas? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cond. Formating
Thanks, I tried that and it still didn't work. It formats everything (before,
after and even today's date). My cells are formated to "date" so that's not the problem. Scratching my head... "JW" wrote: Not sure how the dialog box looks in 2007, but in 2003, simply select Cell Value Is, Less Than, and =Today() in the fields. Caroline wrote: I would like to format dates prior to "today" in red. I have 2007. My guess is I should use a formula when selecting a rule type, but <today() doesn't seem to work. Any ideas? Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cond. Formating
Are you sure that as well as being formatted to date the cells actually
contain dates, not text? If you've got today's date in a cell, change the format temporarily to number and see whether it shows 39345. Also, go back into the CF dialog box and make sure that it is really showing what you think you've put in there, and (for example) that it hasn't thrown spurious quote marks around anything (which it tends to do if (for example) you didn't type in the = before today(). -- David Biddulph "Caroline" wrote in message ... Thanks, I tried that and it still didn't work. It formats everything (before, after and even today's date). My cells are formated to "date" so that's not the problem. Scratching my head... "JW" wrote: Not sure how the dialog box looks in 2007, but in 2003, simply select Cell Value Is, Less Than, and =Today() in the fields. Caroline wrote: I would like to format dates prior to "today" in red. I have 2007. My guess is I should use a formula when selecting a rule type, but <today() doesn't seem to work. Any ideas? Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cond. Formating
That was it: the = sign. I thought since it added it anyways I didn't have to
put it in, but it turned out I did. Thanks much! "David Biddulph" wrote: Are you sure that as well as being formatted to date the cells actually contain dates, not text? If you've got today's date in a cell, change the format temporarily to number and see whether it shows 39345. Also, go back into the CF dialog box and make sure that it is really showing what you think you've put in there, and (for example) that it hasn't thrown spurious quote marks around anything (which it tends to do if (for example) you didn't type in the = before today(). -- David Biddulph "Caroline" wrote in message ... Thanks, I tried that and it still didn't work. It formats everything (before, after and even today's date). My cells are formated to "date" so that's not the problem. Scratching my head... "JW" wrote: Not sure how the dialog box looks in 2007, but in 2003, simply select Cell Value Is, Less Than, and =Today() in the fields. Caroline wrote: I would like to format dates prior to "today" in red. I have 2007. My guess is I should use a formula when selecting a rule type, but <today() doesn't seem to work. Any ideas? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formating - dragging a cond. format over an entire col | Excel Worksheet Functions | |||
| cond formatting | Excel Discussion (Misc queries) | |||
| cond formatting ? | Excel Worksheet Functions | |||
| copying table with cond.formating using value and resulting color | Excel Discussion (Misc queries) | |||
| Cond formatting | Excel Discussion (Misc queries) | |||
Linear Mode
