Forum Discussion
Solved
2 subject formatting
I have a simple spreadsheet that contains a date on the left, and cells to the right that I would like to format if 2 conditions are met. If the cell is empty, and if it is the current date. If y...
I don't know why but I really screwed up writing this.
First I meant to say "2 condition formatting", not 2 subject formatting.
Next, I also screwed up by putting the "current date" rather than the "current month" in the question.
I did get an answer on another forum with:
=AND(MONTH($A2)=MONTH(TODAY()),ISBLANK($B2))
The only issue is that my spreadsheet shows 2 years on it, and the same month the next year also highlights.
I meant to come back and edit the question, but got busy and kind of spaced off about it. Sorry about that.
Anyway, thanks.
First I meant to say "2 condition formatting", not 2 subject formatting.
Next, I also screwed up by putting the "current date" rather than the "current month" in the question.
I did get an answer on another forum with:
=AND(MONTH($A2)=MONTH(TODAY()),ISBLANK($B2))
The only issue is that my spreadsheet shows 2 years on it, and the same month the next year also highlights.
I meant to come back and edit the question, but got busy and kind of spaced off about it. Sorry about that.
Anyway, thanks.