Highlight the cell date of current month

[kashish]

If Any Row having different due dates , So I want a Conditional formula for
showing current month dates highlighted.

 

[Fred Smith]

You want something like:
=month(a1)=month(today())

Regards,
Fred.

 

[Jacob Skaria]

=AND(E1>0,MONTH(E1)=MONTH(TODAY()))

If you are new to CF

1. Select the cell/Range (say E1:E10).
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the formula. Please note
that the cell reference E1 mentioned in the formula is the active cell in the
selection. Active cell will have a white background even after selection
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK


If this post helps click Yes

 

[Jacob Skaria]

Better to include year...
=AND(E1>0,TEXT(E1,"mmyyyy")=TEXT(TODAY(),"mmyyyy"))

If this post helps click Yes