use a cheat row with the formula...
=INT(RAND()*10)+1
where '10' is the range of random #s generated (1-10).
Then create a conditional format that says
Cell Value Is...Equal To...5 (I randomly chose the # 5 for this example :O)
This will only highlight the randomly generated #5 - about 10% of the rows.
Change the '10' to 100 and only about 1% of the rows will have the randomly
generated #5 and therefore meet the conditional formatting criteria.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Willie" wrote:

I have a spreadsheet that has data in A1:J4163 but the size is not always the
same.
My question: Is there a way that I can make a formula, VBA or Contitional
formating to select rows randomly and color fill the rows