Way to sort groups of numbers and change color? 1

[pyromedic]

I need to search large groups of numbers and change the color of any matching single numbers found. What is the best program to use and how do I accomplish it?

Thanks for any input!

 

[luceze]

Using Excel use conditional formatting on the range of cells that you want the color change to happen to. Set the conditional formatting formula to equal a cell that you want to enter your criteria. If a number in your range equals the criteria cell it will change to whatever color you selected in the conditional formatting format cell. Search for conditional formatting in the help file for more information.

 

[pyromedic]

Thank you Luceze! I'll try it out tomorrow.