VBA or Conditional Formatting for end of month BUT MORE COMPLICATED

Hello,

I have a list that starts on the 16th of one month and ends on the 15th of the next month which is attachedAttachment 442249. I currently have 31 rows, because the longest month has 31 days. I would like to either of the below, and am interested to hear if #1 can even work/ what your recommendations might be:

1. Use VBA to add or delete rows the last 3 row (numbered 29-31 in column A) if the month is only 28, 29 or 30 days
2. Use conditional formatting to turn all of the text color and fill color white, OR just delete the text?

Thank you in advance!

Hi there,

Take a look at the attached workbook and see if it does what you need.

It uses formulas and conditional formatting based on the dates to show/hide the dates and text in the last three rows of the table.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi again,

The attached version of the previous workbook uses Conditional Formatting to remove the borders from whichever of the bottommost rows is/are appropriate.

Hope this helps - please let me know how you get on.

Regards,

Greg M

I'm don't think that solves the problem: If I set B12 to 2/16/16, I want B41 & B42 to either have white text and fill or be deleted.

But I may be misunderstanding your formula?

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated

I´m not sure if you gave me the Reputation before or after your last post, but I´m away from my computer and Excel for the next week. Let me know if you still have a problem and I´ll take a look at it when I get back.

Best regards,

Greg M