How to Choose Random Sampling in Excel. Randomly selected samples from a larger population prevent bias in statistical procedures while avoiding the hassle of dealing with the entire dataset.

Use Excel's conditional formatting feature to look at a specific cell in the row, determine if it's negative or positive and format the row based on the results.