Conditional Formatting the Month with automatic monthly progression.

[Kurtis]

GentlePeople,

I have a Question about How to get my "month" selection to automatically increment +1 for each new month?

I have a few different ways that I have thought it should work, but doesn't.

Circle the Month:

1

2

3

4

5

6

7

8

9

10

11

12

<tbody>
</tbody>

This is the way the month setup is currently.

What I want is for the numeric month date to increment +1 when the month become February. Or when it rolls to March I'd like for it to format the number 3.
This is what I had originally: =MONTH(LastModified()) Where it was setup with "Format only cells With: Cell Value_Equal to:

This worked for two months and then it broken somehow.

So I ignored it for a while but I'm revisiting the topic.

This is where my current thinking is: =IF(MONTH = TODAY AND ($V$2), ($V$2), Else ($V$2))
But I get a #NAME ? error.
Anyone have thoughts on how I can get this to function correctly?

Thanks.

 

[oldbrewer]

try today()

 

[oldbrewer]

							col H
	row 11		Circle the Month:	1	2	3	4	5	6	7	8	9	10	11	12
							you have to believe me, 2 is colored red
							I put this conditional format formula into H11 (the 1)
							and then painted it from 2 to 12
							=H11=(TEXT(TODAY(),"m"))*1

<colgroup><col span="5"><col><col><col><col><col><col><col><col span="8"></colgroup><tbody>
</tbody>

 

[Kurtis]

Let me check it out and I'll update in a sec.

							col H
	row 11		Circle the Month:	1	2	3	4	5	6	7	8	9	10	11	12
							you have to believe me, 2 is colored red
							I put this conditional format formula into H11 (the 1)
							and then painted it from 2 to 12
							=H11=(TEXT(TODAY(),"m"))*1

<tbody>
</tbody>