Excel Conditioning

[Wadzy97]

Hey everyone, how would you use the conditional formatting to highlight in a table the terms that are divisible by a number which is controlled by a slider? (1-25) the number that's controlled by the slider is in B17 and the table is B3-I14

 

[MarcelBeug]

Try:

=0=MOD(B3,$B$17)

 

[Wadzy97]

Thank you so much mate! Muchly appreciated!