Gregory123987
New Member
- Joined
- Jun 23, 2020
- Messages
- 33
- Office Version
- 2016
- Platform
- Windows
I had needed a solution to automatically provide conditional formatting if there were consecutive days with values. Unfortunately, the solution that was found did not highlight the 3rd consecutive cell for the current month if there were more than 2 cells ending the previous month. The 9 hidden columns to the left of column M have a value if column J (previous month) has a value.
The same issue applies for 5 and 10 cells as well, but I can fix this myself if someone can help with a solution for the 3rd consecutive cell issue I just described. A link to the previous thread is below.
FYI - I did not do a proper job of testing it as time was of the essence. It has been a year since then and I noticed the issue as I was making changes to the spreadsheet. Thank you in advance for your help.
The same issue applies for 5 and 10 cells as well, but I can fix this myself if someone can help with a solution for the 3rd consecutive cell issue I just described. A link to the previous thread is below.
FYI - I did not do a proper job of testing it as time was of the essence. It has been a year since then and I noticed the issue as I was making changes to the spreadsheet. Thank you in advance for your help.
It took me a while but I managed to figure out a solution. Here it for your info. Thanks for your help.
Added hidden columns, View attachment 19961
Expanded conditional formatting to include applicable columns, wrapped Column with And and added cell reference such as the following to change from
=COLUMN()=(MIN(IF(($M18:$AG18<>"")*($M18:$AH18<>"")*($M18:$AI18<>""),COLUMN($M$16:$AG$16)+2))) to
=AND($J18<3,(COLUMN()=(MIN(IF(($T18:$AP18<>"")*($U18:$AQ18<>"")*($V18:$AR18<>""),COLUMN($T$16:$AP$16)+2)))))