Microsoft Office Forums - View Single Post - Conditionally Highlighting Blank Cells by Quarter in Current Calendar Year

Thread: Conditionally Highlighting Blank Cells by Quarter in Current Calendar Year

View Single Post

Old

11-27-2019, 10:32 AM

PrincessApril PrincessApril is offline

PrincessApril is offline

PrincessApril uses Windows 10

Windows 10 PrincessApril uses Office 2019

PrincessApril uses Office 2019

Office 2019

Competent Performer

The original poster

Join Date: Nov 2019

Posts: 102

PrincessApril is on a distinguished road

Default

I think this is working but will confirm in a bit after I have time to play with it more:

=AND($K5="",MONTH(E5)>3,YEAR(E5)=YEAR(TODAY()))

where K5 is a cell that displays the last day of current year, and E5 is the active cell.

Reply With Quote