Forum Discussion
Which formula to use for conditional formatting
Which formula should I use to add a border to a row if the date = last day of the month
2 Replies
I figured it out. =MONTH($A1)<MONTH($A2) When i apply this formula to my conditional formating of my sheet. It automatically places a border in the last row if the new row is a new month. Hope this helps someone else...
the first column in my sheet is Date. it does not contain every day in the month only the dates i recieved income. i need to add a border to seperate the months in the sheet.
