Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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 at 17:54

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.