Hi

I have an excel sheet with data in range A1:G1000. I need a random
sampling function to just highlight say about 5% of the rows in a
different colour, or show them on a different cell range in the same
sheet.

i tried using RAND() but it doesnt seem like what I am looking for.

Cheers
Sunny