Hi Guys,
Is there a way of creating a formula to show the value of which ever cell is coloured Green within a the same row
I have a Spreadsheet has a column to the right that shows the selected value for each row. This value currently is just a simple =A2 value. A2 is then coloured Green to show which value was used.
B2 would have an another value but if its not chosen it would just be left blank for future reference.
<tbody>
</tbody>
Thanks for all your help
Is there a way of creating a formula to show the value of which ever cell is coloured Green within a the same row
I have a Spreadsheet has a column to the right that shows the selected value for each row. This value currently is just a simple =A2 value. A2 is then coloured Green to show which value was used.
B2 would have an another value but if its not chosen it would just be left blank for future reference.
Survey 1 | Survey 2 | SELECTED RESULTS |
20040 (GREEN) | 500 | 20040 {Formula required} |
3000 | 5100 (green) | 5100 {Formula required} |
<tbody>
</tbody>
Thanks for all your help