Hi,

I have a worksheet that uses two scroll bars to alter data. The sum of the two cells should not exceed 1. I have added conditional formatting to highlight the cell if this value goes over 1. Is there a way to prevent this from exceeding 1 with a warning when using the scroll bars. I can limit the direct input of a cell with Data validation but couldn't get this to work with the scroll bars.

Any help would be much appreciated.


Example attached.

scroll.xlsm