Home

Excel Cell Conditional Formatting Help!

Mr_Chahal
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:

S-P.jpg

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

 

Thanks.

1 Reply

Hi,

 

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
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 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
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies