Excel Cell Conditional Formatting Help!

Occasional Visitor

Hi all,


I am looking to superimpose 2 lines on a set of raw, binary data (1s and 0s). To do this I want to use cell borders and would like it to be automatic related to the data that is inputted into the spreadsheet.


The black line (look from bottom left) continues straight for 5 cells because the total number of 1s is 5 as seen in the total cell (bottom far right). It then goes up one cell because the next total is 6. the line continues to go up by 4 cells because the next 4 totals are 6. So on and so forth.


Same principle applies to the red line with the bottom row total scores. 


Please see an example below:


I'd really appreciate some advice and help to see how I could go about automating this process rather than manually doing it.



1 Reply



It'll be easier if you provide sample file to play with, to reproduce it is a bit time consuming.


Thank you

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies