Re: Require Cells Between Two Values to be Filled with "1"
So I have managed to upload the file - which I hope will help solve the challenge I am facing!
I hope that the actual data makes finding a solution easier, all I really want is for the 1's that are on the same row to be linked by a colour (refer attachment example). Was under the impression that I needed conditional formatting - but this doesn't exactly work!
Thanks in advance all!