Highlight your range
condition Formatting Cell Value Is Equal to 5
Format any color you want


"packfan" wrote:

How can I change the colour of one number and make all of the other numbers
that are the same change colour?? For example: if I would like to change the
colour of the number 5, how can I make all the other number 5's that I type
be the same colour.

Thanks