Forum Discussion
Josh Bee
Apr 08, 2018Copper Contributor
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 
Josh Bee
Apr 08, 2018Copper Contributor
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...