How to highlight entire row if met the current month date by using conditional format

[Yvonneyeong]

Help please !!! How to highlight entire row if met the current month date by using conditional format

 

[deciog]

Check if this is the way you want it

Decio

 

[Fluff13]

Use
=MONTH($F16)=MONTH(TODAY())

 

[Yvonneyeong]

Use
=MONTH($F16)=MONTH(TODAY())

Thanks so much!!! I've tried your formula, but why it doesn't work? Where goes worng? Please advise.

 

[Peter Bartholomew]

Your formula has an absolute reference to cell $F$16 rather than a relative reference to column F of the row containing the active cell, e.g $F16 if a cell in row 16 is selected.

 

[Yvonneyeong]

Your formula has an absolute reference to cell $F$16 rather than a relative reference to column F of the row containing the active cell, e.g $F16 if a cell in row 16 is selected.

Alright, thank you very much!!!