assigning a numerical value to a colored cell

ChrisBlair 

Hi Chris,

When I recommended an If statement (before you attach a file), I assumed that you are coloring the cells based on a conditional formatting rule that reads a value. 
Now the situation when I look at your file is totally different because I cannot create a conditional rule that returns a number based on color (Except in VBA- I can send you a link for that but it's complicated).
So, alternatively, I am going to use a very simple technique to select All Cells with a specific color and type a number in All of them simultaneously:

1. Click on "Find & Select" to the right side of the Home Tab
2. Select Find...
3. Click on Options >> The box expands
4. Click on Format >> Select the Eye Dropper tool
5. Click on one of the colors in the worksheet
6. Click Find All >> The box Expands
7. Hit CTRL +A >. you selected All cells of that color
8. Close the Find box and Do Not Click anywhere
9. Type the number (Say 1) Then Hit CTRL + ENTER (not enter)
10. Repeat for each Color

Hope that Helps

Nabil Mourad