1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Boxing using conditional formatting

Has anyone got any ideas how I could make the below using conditional formatting? I need to group each payment together based on the code on the right and group them together by using the border option.

I've been able to get it to work for payments that are in a single column but I can't seem to figure out how to make it work for the double boxes

https://preview.redd.it/085vv1cvw3mg1.png?width=393&format=png&auto=webp&s=567f78966535a77dec353ff8d7a8084824925092

submitted by /u/just_a_comment1
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#cloud-based spreadsheet applications
#no-code spreadsheet solutions
#conditional formatting
#payments
#grouping
#border option
#code
#double boxes
#single column
#Excel
#formatting
#ideas
#work
#preview
#submitted by