I have a question regards to conditional formatting (highlighting) and what formula to use please.
I have 4 rows A, B, C, D
If A2 has any of these numbers - 1, 2, 3 and "D2" has any of apple, oranges, grapes, banana. I like the "ABCD" to highlight green.
If A3 has any of these numbers - 4 , 5, and "D2" has any of cauliflower, egg plant, capsicum, chillies etc. I like the "ABCD" to highlight yellow.
what formula to use please and many thanks in advance for your time and response.
I have 4 rows A, B, C, D
If A2 has any of these numbers - 1, 2, 3 and "D2" has any of apple, oranges, grapes, banana. I like the "ABCD" to highlight green.
If A3 has any of these numbers - 4 , 5, and "D2" has any of cauliflower, egg plant, capsicum, chillies etc. I like the "ABCD" to highlight yellow.
what formula to use please and many thanks in advance for your time and response.