Formula for CF to color current month

C

computexcel

My extense worksheet of DATES need to color RED the cell that has the date of
the current month( ex.. 9/2/8, 9/10/8, 930/8 ), and will change accordinly to
each month.
I guess using a formula in conditional formatting, but I have not been able
to figure it out after trying diferent formulas. Open for formulas. Thanks.
 
D

Dave Peterson

Select your range to format

I selected A:E and with A1 the activecell:

Formula is:
=text(a1,"yyyymm")=text(today(),"yyyymm")

This checks both year and month.

If you only cared about the month:
Formula is:
=month(a1)=month(today())
 
C

computexcel

Thanks Dave, Wonderformula!

Dave Peterson said:
Select your range to format

I selected A:E and with A1 the activecell:

Formula is:
=text(a1,"yyyymm")=text(today(),"yyyymm")

This checks both year and month.

If you only cared about the month:
Formula is:
=month(a1)=month(today())
Click to expand...
 
Top