Custom or conditional format to highlight today's date?

Using Excel 2002, I have all 365 days of the year listed in column B,
formatted as "03/14/01". When i open the workbook, I would like the
current date to be bold and red. Can I do this with a conditional
format?
I have tried    =Today   with no success.

Thanks

Tonso
0
wthomasss (97)
4/3/2009 12:03:38 PM
excel 39879 articles. 2 followers. Follow

4 Replies
456 Views

Similar Articles

[PageSpeed] 35

"Tonso" <wthomasss@hotmail.com> wrote in message 
news:13885af2-777c-43ff-9684-1b5bda8d95d6@o6g2000yql.googlegroups.com...
> Using Excel 2002, I have all 365 days of the year listed in column B,
> formatted as "03/14/01". When i open the workbook, I would like the
> current date to be bold and red. Can I do this with a conditional
> format?
> I have tried    =Today   with no success.
>
> Thanks
>
> Tonso

As a purely amateur user of excel - I only managed to do this by making 
a1=Now() and then conditional formatting the dated cells as: Cell Value Is | 
Equal to | =A1, I had to delete the quote marks that conditional formatting 
put in - I stress I'm only an amateur!

I look forward to a professional solution.

Peter 


0
p.andrews (27)
4/3/2009 1:04:34 PM
On Apr 3, 9:04=A0am, "Peter Andrews" <p.andr...@blueblueyonder.co.uk>
wrote:
> "Tonso" <wthoma...@hotmail.com> wrote in message
>
> news:13885af2-777c-43ff-9684-1b5bda8d95d6@o6g2000yql.googlegroups.com...
>
> > Using Excel 2002, I have all 365 days of the year listed in column B,
> > formatted as "03/14/01". When i open the workbook, I would like the
> > current date to be bold and red. Can I do this with a conditional
> > format?
> > I have tried =A0 =A0=3DToday =A0 with no success.
>
> > Thanks
>
> > Tonso
>
> As a purely amateur user of excel - I only managed to do this by making
> a1=3DNow() and then conditional formatting the dated cells as: Cell Value=
 Is |
> Equal to | =3DA1, I had to delete the quote marks that conditional format=
ting
> put in - I stress I'm only an amateur!
>
> I look forward to a professional solution.
>
> Peter

Peter,

That works with the Today function for me, and is a good solution.
Thanks!!  I am still wondering why my condtional format formula,
=3DToday  , did not work.
0
wthomasss (97)
4/3/2009 1:52:39 PM
On Apr 3, 9:52=A0am, Tonso <wthoma...@hotmail.com> wrote:
> On Apr 3, 9:04=A0am, "Peter Andrews" <p.andr...@blueblueyonder.co.uk>
> wrote:
>
>
>
>
>
> > "Tonso" <wthoma...@hotmail.com> wrote in message
>
> >news:13885af2-777c-43ff-9684-1b5bda8d95d6@o6g2000yql.googlegroups.com...
>
> > > Using Excel 2002, I have all 365 days of the year listed in column B,
> > > formatted as "03/14/01". When i open the workbook, I would like the
> > > current date to be bold and red. Can I do this with a conditional
> > > format?
> > > I have tried =A0 =A0=3DToday =A0 with no success.
>
> > > Thanks
>
> > > Tonso
>
> > As a purely amateur user of excel - I only managed to do this by making
> > a1=3DNow() and then conditional formatting the dated cells as: Cell Val=
ue Is |
> > Equal to | =3DA1, I had to delete the quote marks that conditional form=
atting
> > put in - I stress I'm only an amateur!
>
> > I look forward to a professional solution.
>
> > Peter
>
> Peter,
>
> That works with the Today function for me, and is a good solution.
> Thanks!! =A0I am still wondering why my condtional format formula,
> =3DToday =A0, did not work.- Hide quoted text -
>
> - Show quoted text -

I found out why my  =3DToday conditionla format formula di dnot work. It
should have been   =3DToday(). Even though no arguments are required. I
should have known better.

Thanks again,

Tonso
0
wthomasss (97)
4/3/2009 2:33:46 PM
in 2003  conditional formatting on column works with "cell value is"  "equal 
to" =today()

Eric

"Tonso" <wthomasss@hotmail.com> wrote in message 
news:13885af2-777c-43ff-9684-1b5bda8d95d6@o6g2000yql.googlegroups.com...
> Using Excel 2002, I have all 365 days of the year listed in column B,
> formatted as "03/14/01". When i open the workbook, I would like the
> current date to be bold and red. Can I do this with a conditional
> format?
> I have tried    =Today   with no success.
>
> Thanks
>
> Tonso 


0
ericNOSPAM (46)
4/3/2009 4:44:39 PM
Reply:

Similar Artilces:

anther date question
StrDate is assigned todays date with the Now function, the value looks like this: 3/25/2010 10:36:48 PM ....I need the value to look like this: 2010/03/25 (the month and day have to be 2 digits) How do I do this? thanks. "Southern at Heart" <SouthernatHeart@discussions.microsoft.com> wrote in message news:E67D6548-98E2-4274-B774-E7300C3A3877@microsoft.com... > StrDate is assigned todays date with the Now function, the value looks > like > this: > 3/25/2010 10:36:48 PM > > ...I need the value to look like this: > 2010/03/25 > (the...

Formatting a variable
I have the following code: Type ProdMatrix APN As Single ..... Dim ThisProd As ProdMatrix ..... tmpThisProd.APN = .Cells(tmpSrcRow, 2) The variable is supposed to contain the number 9317382120228, but instead contains 9.317382E+12 Then, when I execute the following code: With ThisProd Cells(LastRowDest, 1) = .APN & .StoreNo I get the result of 9.317382E+123201 in the cell where: ThisProd.APN = 9.317382E+12 ThisProd.StoreNo = 3201 I was expecting to get the number 93173821202283201. Why is the value of APN taken literally and not by...

Printing or formatting issue?
Dear all, Please bear with me on this one, I have posted something similar in the past and thought this issue had been resolved but hasn't!! In Finance we have staff who work on individual worksheets, these are then sent to one person who collates them into one workbook; this is then sent to our Finance MD and PA. The person who sends the workbook can print all sheets out fine on his HP5000n (A4 and A3), however the Finance PA (HP4050) and the MD (HPxxx) cannot, they complain that the formatting is all "off". I can confirm that all these users and those who originally created t...

conditional formating 04-28-10
I have the following formula for column D and E =D2<Today() red =(D2-Today())<30 green I need to add a formula that if a date is in column c then column D and E are black. What are you formatting? The font color or the cell fill color? -- Biff Microsoft Excel MVP "Cheryl" <Cheryl@discussions.microsoft.com> wrote in message news:6C0EA3C7-7A01-42EB-9AF0-0B8E7DC99915@microsoft.com... >I have the following formula for column D and E > =D2<Today() red > =(D2-Today())<30 green > I need to add a formula that if a date is in column c th...

opening a new document w/ a custom stencil open
I have created a custom stencil for users in my workgroup and saved the file to a network directory. Currently, to use it we do FILE>SHAPES>OPEN STENCIL and navigate to the file. I'd like to make this more transparent. What I'd like to do is have something where the user does FILE>NEW and when I get the "Choose New Drawing Type" I'd like to insert my custom 'templates' (not sure if that's the right term in Visio) and when the user selects one of those it opens the editing window w/ my custom stencils already loaded. IOW, I want it to work just like o...

Excel Regional Date Format Options
A client of ours in NZ is complaining that date format options for English (New Zealand) have changed from older versions of excel (they are using 2003) Some of their spreadsheets have dates formatted as dd-mmm-yy, mmm-yy and dddd,dd,mmm but these options do not exist anymore. Is there anyway to add options to this list without using the custom format option? Thanks, Jesse I just compared the Excel 97 and Excel 2003 built-in date formats and they are mostly unchanged. 2003 has a few more but I don't think there were any subtractions. The formats dd-mmm-yy and mmm-yy are righ...

When I am in one cell highlight another
Hello, When I am in one cell highlight another. Lets say that if my cursor is in A1 I want D1 highlighted or with another cursor on it. Then if I move to A2, D2 should be the one with another cursor or highlighted. Thank you for your help, Jose Juan Diaz hi, Jose Juan ! > When I am in one cell highlight another > ... if my cursor is in A1... D1 highlighted or with another cursor on it. > ... if I move to A2, D2 should be the one with another cursor or highlighted. 'put' a cursor on non-active-cell... [I don't think it's possible] :( to highlight 'D' wh...

Copying Border Formatting
Hi folks, I have a large spreadsheet which is essentially a diary. I want to format the days and weeks, with thin and thick borders to distinguish between them. The spreadsheet already has lots of varied fill formatting for meetings that are held. I can't see a way of either format painting, or paste special-ing, just borders. Is it possible? Thanks -- StainlessSteelRat http://www.stainlesssteelrat.net Stanley: It's not gonna end like this. Gabriel: Oh, come on, Stan. Not everything ends the way you think it should. Besides, audiences love happy endings. True enough that...

Changing a customers Account Number?
Is it safe to edit a customers account number? I have some irregularities i would like to sort out, and would rather maintain the customers purchase history than make a new account? If i directly change the account number - will i mess anything up? In my personal opinion if the account number was system generated, I'd leave it alone; if you created your own account numbers for your customers, I don't think you'll have any issues, sql being a relational db and all.....nevertheless, back up your db and recreate it on say your laptop....then change one customer account numb...

Format>Row>Autofit
Hi in Excel 2003, I have a 380row x 2col sheet, all text, no functions so far. Text was imported from Word, other Excels etc. Up to 10 lines of text in some cells, word-wrapped, many new-line (Alt + Enter) breaks. No merged cells. Problem is, Format>Row>Autofit is unreliable. For 90% of cells works fine but some either show white space between text lines, or shrink too much, cutting off last text line(s). If adjusted manually, seems unstable - will revert for no reason. Looks like you need to remove the formatting before you pasted into the new spreadsheet. when youu paste - if you ...

Save document in 9 slide format view
How do I save the document in the 9 slide format view vs. the individual panes? I would suggest printing the document to pdf. select handouts and set to 9 slides per page. hope that helps -- Emma Bannister PowerPoint Specialist www.presentationstudio.com "D @ rrcsb" <D @ rrcsb@discussions.microsoft.com> wrote in message news:7582D4E9-7BA8-417F-81AE-9603F4D00B87@microsoft.com... > How do I save the document in the 9 slide format view vs. the individual > panes? ...

custom button id
Hello, Help me please. I've created custom button with title 'Reject' in ISV.Config for toolbar case entity detail form. I need diasable and enable this button in JavaScript. I've found id this button in detail form view source - 'ISV_New_780_Reject'. But then this id has changed. And now it is 'ISV_New_596_Reject'. How do I have to determinate custom buttons id properly? Thank you very much! Hi, >From my previous experience, the button id should not change unless they change the way of how button is created in CRM recently. Are you trying to move from...

Sum If
I want to sum a # field if the 2 conditions are met. 1 - the month = February and 2, the $'s are sales Data is like this D F G Month Measure(Sales) Data I want to add penguin77 wrote: > I want to sum a # field if the 2 conditions are met. 1 - the month = > February and 2, the $'s are sales > > > Data is like this > > D F G > Month Measure(Sales) Data I want to add > http://www.contextures.com/xlFunctions01.html#SumProduct In ...

conditional format rage based on entries within range
I have a spreadsheet in excel 2003 where a range of cells contain different text. If there is no text in any of the cells within the range I would like the range conditionally formated (red), however if any or all of the cells within the range contain text then no format should be applied;e.g. If A1 to D1 are blank format cells red, when text is entered into B1 remove formatting. All help greatly recieved. Simon. Simon, Select A1 to d1 and then format|Conditional formatting - Select 'formula is' enter the formula =A1="" Pick a colour OK -- Mike...

Highlight Row when selected
hi is it possible to highlight a row when you select a cell on a row. For example I select B28, the row B becomes highlighted, then when click on B29 that one becomes highlighted and B28 become un-highlighted. The only cells on each row i wont highlighting is B:I. Thanks : -- cassy0 ----------------------------------------------------------------------- cassy01's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=78 View this thread: http://www.excelforum.com/showthread.php?threadid=42201 Good morning (again) Cassy01 Chip Pearson provides an add in that will...

highlighting rows according to a input value?
eg. value 1 and 2 in a cell should make an entire row red eg. value 3 to 6 in a cell should make an entire row blue Ideally I want a formula when if I put 1 or 2 into a cell it highlights the row as red maybe I if I input a 3, 4, 5, 6 it highlights red Any thoughts? Thanks in Advance. This can be done with conditional formatting. <FORMAT> - <CONDITIONAL FORMATTING> specify your criterium and set your format. Success "tlai909@visto.com" wrote: > eg. value 1 and 2 in a cell should make an entire row red > > eg. value 3 to 6 in a cell should make an ent...

Custom Line Width in Line or Scatter Chart
Is there any way to create lines of a custom width in a line or scatter chart? I occasionally have a need for a very thick line, thicher than the maximum that the dialog allows? Thanks. Marvin - You can fake it. I have published a few macros that draw lines and other shapes which trace lines on a chart: http://peltiertech.com/Excel/Charts/VBAdraw.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Marvin" <Marvin@discussions.microsoft.com> wrote in message news:9EEBCF8D-2F37-4F6A-9FA3-2D82D845F1BE@mic...

Conditional DELETE
Hello everyone, Before I get into the meat and potatoes of this macro, column "H" will have a red (5) background put there by conditional formatting. So really not sure if this approach will work, but here goes. Check range Sheet1 (H5:H1968) for cell background = Red (5) if TRUE do nothing. If cell background = White (46) (or default I think), then DELETE each cell contents in Sheet1 column (I5:I1968) that condition applies too. -Thanks Any help would be appreciated. Ray Default is No Color which is -4142 Gord Dibben XL2002 On Thu, 13 Nov 2003 15:18:06 -0800, RayD <rc...

date format frustration!
I'm having no luck! When I enter 07/29/2004 it comes out 36735. I've tried the format option but no luck...what am I missing? Thanks in advance! Hi formating this cell as 'Date' should do -- Regards Frank Kabel Frankfurt, Germany "ogawak" <ogawak@discussions.microsoft.com> schrieb im Newsbeitrag news:32299F17-318F-4770-B08E-9032FDE63AE5@microsoft.com... > I'm having no luck! When I enter 07/29/2004 it comes out 36735. I've tried > the format option but no luck...what am I missing? > > Thanks in advance! Check your Date settings at T...

Update Date & Time
I am new to Micrsoft Money and need help. The date and time on my computer and in Micrsoft Monay are both correct, however the date and time it gives me when I update new information from my bank is two days ahead of the current date. It keeps throwing me off. For instance, when I downloaded new information today May 20, 2005 at 7 pm on the home page it tells me it was last updated May 23 at 12:00 am. I can find no way to change this. I am running Money 2005 basic. Any help is greatly appreciated. Thank you Vicki Did you have to have a Passport to download data from your bank? ...

Dealing with Office 2007 & Office 2003 file formats
My company plans on moving to Office 2007 soon. However, we have a delimma with how to handle how Office files are saved. For example, if a person open a .doc & makes changes in Office 2007 and some of those changes are not supported by the .doc, then the file is saved as a ..docx. This leaves us with two files... a doc & a docx. We really don't want someone updating the .doc anymore. Any suggestions on how to deal with this? Side notes: ~We have the compatibility pack installed on all computers. ~The batch converter tool doesn't seem like a good fit for...

cannot customize outlook Today #7
When user clicks on the "Customize Outlook Today" button, noting happens. I upgraded his OUtlook 2000 to SP3. Did a fix and repair. And renamed the outwvw.dll file to outwvw.old when you go to properties of outlook today from the folder list - home page tab - the restore defaults is grayed out. any help is greatly appreciated. See if this helps http://support.microsoft.com/default.aspx?scid=kb;EN-US;820575 "ilene" <anonymous@discussions.microsoft.com> wrote in message news:03f101c3d4af$b3ba6b50$a501280a@phx.gbl... > When user clicks on the "Customiz...

Have 2004 and 2005 dates in worksheet
Hello, I've got Excel 2002 SP3. I have an ad schedule that lists closing dates for 2005 magazines. Some of the early 2005 issues (January and February) close in November and December 2004. March and subsequent issues close beginning in January 2005. I put the closing dates in the cells as 11/16 and 12/16 for Jan-Feb and it automatically adds the 2004. When I enter 1/16, I want it to add 2005 instead of 2004. Can this be done? Thanks. If you type only the month and day, Excel assumes the current year, as described in the following MSKB article: http://support.microsoft.com/d...

Formatting Problem #2
I have a concatenated formula in cell A1 (contains both text and numbers). I am trying to format the cell, right justified, with spaces to the right of the value displayed. I have been successful by formatting the cell as @" ". However, when I format the cell in this manner, I can no longer modify the formula and have it entered as a formula. When I remove the formatting, I can then modify the formula which now is a working formula, and then format it again as above. This of course seems very strange, so I must be doing something wrong by formatting with @" "....

Border lines on the side of the date cell partially missing
Outlook 2003 (version 11.8118.8107) on XP SP2 Pro. As of few days ago my Calendar appears with the border lines on the side of the date cell partially missing. They are white or gray roughly the height of the adjacent date number, while the rest of the line is OK (black). Any ideas? I'm trying to picture this...can you give me a little more detail? What view are you using? (monthly, daily, etc) Which side? (right, left) Could it be that you have an appointment booked during that time? Nikki Peterson "Jerry" <duncan_jeremy@hotmail.com> wrote in message news:...