Changing the colour of text

P

packfan

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
 
T

Teethless mama

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