Highlight the cell date of current month

  • Thread starter Thread starter kashish
  • Start date Start date
K

kashish

If Any Row having different due dates , So I want a Conditional formula for
showing current month dates highlighted.
 
=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
 
Better to include year...
=AND(E1>0,TEXT(E1,"mmyyyy")=TEXT(TODAY(),"mmyyyy"))

If this post helps click Yes
 
Back
Top