Conditional formatting which is referenced by scroll bar

[Tigerexcel]

Can you link a scroll bar to a cell which returns values and alters conditional formatting?
Say you have a range of data with values ranging between 0 and 100 in C1 to F30. In a particular cell say A1, you want to place a cell to compare against the range of values. I would like to see how many cells in the range of C1 to F30 are greater than or equal to eg 62 (which sits in A1). I would like to be able to alter the cell in A1 via a scroll bar so that I can easily go up to 63 and then down to 57 etc. The conditional formatting should be updating automatically depending on how many cells are greater than or equal to the whatever number is in A1.

 

[Fluff]

You can link the scroll bar to A1 & then
Select C1:F30 & use this CF formula
=C1>=$A$1

 

[Tigerexcel]

Thanks Fluff.

 

[Fluff]

You're welcome.