I would like to to get cell G2 to turn a specific color depending on the matched value value of E2 to the corresponding value in column I. Can someone please assist me with this?
| Excel Workbook | ||||||||
|---|---|---|---|---|---|---|---|---|
| E | F | G | H | I | J | |||
| 2 | 4.2 | 2.1 | Green | |||||
| 3 | 3.1 | Green | ||||||
| 4 | 3.2 | Green | ||||||
| 5 | 4.1 | Green | ||||||
| 6 | 4.2 | Green | ||||||
| 7 | 4.3 | Green | ||||||
| 8 | 5.1 | Green | ||||||
| 9 | 5.2 | Green | ||||||
| 10 | 5.3 | Yellow | ||||||
| 11 | 5.4 | Yellow | ||||||
| 12 | 6.1 | Green | ||||||
| 13 | 6.2 | Yellow | ||||||
| 14 | 6.3 | Yellow | ||||||
| 15 | 6.4 | Yellow | ||||||
| 16 | 6.5 | Yellow | ||||||
| 17 | 7.1 | Yellow | ||||||
| 18 | 7.2 | Yellow | ||||||
| 19 | 7.3 | Yellow | ||||||
| 20 | 7.4 | Red | ||||||
| 21 | 7.5 | Red | ||||||
| 22 | 8.2 | Red | ||||||
| 23 | 8.3 | Red | ||||||
| 24 | 8.4 | Red | ||||||
| 25 | 8.5 | Red | ||||||
| 26 | 9.3 | Red | ||||||
| 27 | 9.4 | Red | ||||||
| 28 | 9.5 | Red | ||||||
| 29 | 10.4 | Red | ||||||
| 30 | 10.5 | Red | ||||||
| 31 | 11.5 | Red | ||||||
Sheet1 | ||||||||
Last edited:
