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

[AA Arens]

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

 

[Bernard Liengme]

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

 

[Dave Peterson]

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")

 

[AA Arens]

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")

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

 

[Dave Peterson]

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

 

[AA Arens]

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



AAArenswrote:

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

Bart

 

[Dave Peterson]

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