Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So I have three colors in column F, green, grey and red. What I want is for column G to display a number (1, 2, 3) depending on the color value of F.

Is there a way to do this?

Here is a link to a doc: https://docs.google.com/spreadsheet/ccc?key=0Am5vN6uut_w5dHdqYWcwTlYxdWQtSklmMVAyd3VuT2c&usp=sharing

share|improve this question
Perhaps you can share a doc with us. It says so much more than words can describe. – Jacob Jan Tuinstra Jul 25 '13 at 14:44
Good idea, added a sample. – Mike Jul 25 '13 at 14:47
Might you consider setting the F colour based on the G value instead, or are the colours set by conditional formatting? – pnuts Sep 25 '14 at 17:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.