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
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...