sparkytech
Board Regular
- Joined
- Mar 6, 2018
- Messages
- 96
- Office Version
- 365
- 2019
I have a sheet which creates a Gantt chart from project dates. Conditional formatting colors the column for the current week. I need a formula to conditional format this column so I can make a bottom border in the cell if it is the last row containing data. In other words, the final result will have a border around the vertical “current week” bar. Everything else works except for the bottom border, I can’t seem to figure that part out. I can’t use VBA unfortunately.