Hi there,
I have a sheet and a column that I manually apply a shade to cells based purely on reading some text in another cell (on the same row). This is called the Grading column. I use four colours in this column; Red, Amber, Green & Yellow. I've then created a separate column that I want to look at the shaded cells and apply an 'R' in the case of Red cell, 'A' in the case of Amber cell...and so on. I've done this so it will help me with producing Pivot tables.
I've attached a paired down version to make it easier to review.
Any assistance would be gratefully received.
Regards
Ben
I have a sheet and a column that I manually apply a shade to cells based purely on reading some text in another cell (on the same row). This is called the Grading column. I use four colours in this column; Red, Amber, Green & Yellow. I've then created a separate column that I want to look at the shaded cells and apply an 'R' in the case of Red cell, 'A' in the case of Amber cell...and so on. I've done this so it will help me with producing Pivot tables.
I've attached a paired down version to make it easier to review.
Any assistance would be gratefully received.
Regards
Ben
AMP Grading_Mar-21.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | ||||||
2 | Grading | Result | ||||
3 | O | |||||
4 | R | |||||
5 | Y | |||||
6 | G | |||||
7 | ||||||
Sheet1 |