Emmily
Well-known Member
- Joined
- Oct 5, 2008
- Messages
- 676
Hi
I am after a formula that will return highlighted data G2:I4 if the criteria is jemma
I am after a formula that will return highlighted data G2:I4 if the criteria is jemma
Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Test1 | Test2 | Test3 | Criteria | Test1 | Test2 | Test3 | ||||
2 | apple | yellow | jemma | jemma | apple | yellow | jemma | ||||
3 | pear | red | tracy | water | red | jemma | |||||
4 | bear | blue | jack | banana | red | jemma | |||||
5 | water | red | jemma | ||||||||
6 | banana | red | jemma | ||||||||
7 | strawberry | black | jack | ||||||||
Sheet2 |