Hi guys,
Let me try to explain my problem:
<tbody>
</tbody>In cell A1 I have a value with a red background colour, in A2 I have a value with no background colour and in cell A3 I have again a value with a Yellow background colour and so on, with different colours and values (non conditional formatting).
I have two questions:
1. In Line 10 I want to have the final result.
This means I want it to give me the last coloured cell. In this case it should present the colour and value of A3, so I want it to be 30 and painted of Yellow. Do you know how to do this automatically? This "final result" is always in line 10.
2. Each background colour represents a brand. In line 11, I wanted it to write the brand "XPTO", so I didn't need to be checking it manually.
I have another table that states the brands:
<tbody>
</tbody>
Thank you!
Let me try to explain my problem:
A | |
1 | 20 (red background) |
2 | 40 |
3 | 30 (yellow background) |
... | |
10 | 30 (yellow background) |
11 | XPTO |
<tbody>
</tbody>
I have two questions:
1. In Line 10 I want to have the final result.
This means I want it to give me the last coloured cell. In this case it should present the colour and value of A3, so I want it to be 30 and painted of Yellow. Do you know how to do this automatically? This "final result" is always in line 10.
2. Each background colour represents a brand. In line 11, I wanted it to write the brand "XPTO", so I didn't need to be checking it manually.
I have another table that states the brands:
colour | Brand |
yellow | XPTO |
Red | ZZBVC |
<tbody>
</tbody>
Thank you!