search for a given number and paint the cells in colors

[Antonio Rosales]

hi!

i put numbers from 1 to 104 in cells from b2 to n9. i want to enter eny number in a textbox and that it searchs me were is that number and every number <= to the introduce one, paint it of a diferent color. i thought of something like this. i know its not correct, but just as an example

Please Login or Register  to view this content.

thanks!

[jraj1106]

Hi.

Try this code:

Please Login or Register  to view this content.

[Norie]

Have a look at the attached.

Not what you want I know but it might give you some ideas.

[Antonio Rosales]

thanks! very useful!