Formating with colar.

A sheet is attach. What I would like to happen is the numbers on the left should be the same color as the ones in red and the rest in black. So if 2 is red when 2 shows up on the left it should be red also. Now this could be done by the font. I hope this is clear.

Are you looking to do Conditional Formatting? Are you saying that if you FILL a cell with Red (or any color for that matter?) that if there is a cell with the same value in the left hand side it should also FILL with the same color?

The red stripes in the middle designates which numbers are to be red. The other numbers in the middle that dont have a background is to be black. I would like when I type in the numbers on the left if it is to be red in would have the color red fit it should be black then it would be black