Conditional formatting =TODAY() works for d (date), not for mmmm (month).

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AA Arens - 15 Jul 2007 12:45 GMT

How to accomplish the following:

I want to perform conditional formatting on a cell range that
indicates the month. I need to use =TODAY() I guess.

How is the cell format for Jan, Feb, etc.
How is the conditional formatting condition?

Thank you for yuor help.

Bart
Excel 2003

Reply to this Message

Bernard Liengme - 15 Jul 2007 12:54 GMT

If A1 contains the formula =TODAY(), then you can fuse Format | Format Cells
and give the cell a Custom format of mmm (to see Jan, etc) or mmmm (to see
January)

Please give more details on what you want in the way of conditional
formatting.
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> How to accomplish the following:
>
[quoted text clipped - 8 lines]
> Bart
> Excel 2003

Reply to this Message

Dave Peterson - 15 Jul 2007 12:55 GMT

If I only wanted to check to see if the months were the same (Jan 2007 will
match Jan 1992), then I'd use a formula like this in the format|conditional
formatting dialog:

=MONTH(A1)=MONTH(TODAY())

If I wanted to make sure I was in the same year, I'd use this formula:

=TEXT(A1,"yyyymm")=TEXT(TODAY(),"yyyymm")

A1 was my activecell in both of these samples.

Select your range and use the activecell in your formula.

If you're formatting a bunch of cells in the same row based on the date in
column A, then change the formula to something like:

=TEXT($A1,"yyyymm")=TEXT(TODAY(),"yyyymm")

> How to accomplish the following:
>
[quoted text clipped - 8 lines]
> Bart
> Excel 2003

Signature

Dave Peterson

Reply to this Message

AA Arens - 15 Jul 2007 15:04 GMT

> If I only wanted to check to see if the months were the same (Jan 2007 will
> match Jan 1992), then I'd use a formula like this in the format|conditional
[quoted text clipped - 31 lines]
>
> Dave Peterson

I was indeed not clear.

This is what I want:

# Column A

1 January
2 February
3 March
4 April
5 May
6 June
7 July
8 August
etc

With conditional formatting I want to highlight the present month. Now
we are in July, and want it yellow (=Cell A7). I know how the
conditions work, the problem is I can't get is yellow. So, there must
be something wrong with the cell format or its contents.

The present cell format is Date = M. I have tried MMMM, but w/o
success

Reply to this Message

Dave Peterson - 15 Jul 2007 17:36 GMT

If you have real dates in the cell, then I think my suggestion would work.

If you have just the month name typed into that cell, then those aren't
dates--they're just text.

You can use a condition formatting formula like:
=a1=text(today(),"mmmm")

I don't understand this note:
The present cell format is Date = M. I have tried MMMM, but w/o

> > If I only wanted to check to see if the months were the same (Jan 2007 will
> > match Jan 1992), then I'd use a formula like this in the format|conditional
[quoted text clipped - 55 lines]
> The present cell format is Date = M. I have tried MMMM, but w/o
> success

Signature

Dave Peterson

Reply to this Message

AA Arens - 16 Jul 2007 07:07 GMT

> If you have real dates in the cell, then I think my suggestion would work.
>
[quoted text clipped - 74 lines]
>
> Dave Peterson

Thanks, Dave it works. I included "=A1" but that was not good.

Bart

Reply to this Message

Dave Peterson - 16 Jul 2007 12:26 GMT

Including A1 would depend on if you used "cell value is" or "Formula is" in the
conditional formatting dialog.

<<snipped>>

> Thanks, Dave it works. I included "=A1" but that was not good.
>
> Bart

Signature

Dave Peterson

Reply to this Message