Brittropp07
New Member
- Joined
- Jan 25, 2016
- Messages
- 3
Hello,
I am trying to figure out how I can have conditional formatting depending on text in one cell relating to value in another cell, but for several different items... for example
DATA
<tbody>
</tbody>
Specification/ Condition:
<tbody>
</tbody>
I would like the cells that do not meet specification turn red.
Thank you!
I am trying to figure out how I can have conditional formatting depending on text in one cell relating to value in another cell, but for several different items... for example
DATA
Item | Value 1 | Value 2 |
Apples | 15 | 43 |
Oranges | 18 | 24 |
Bananas | 7 | 34 |
Mango | 3 | 8 |
<tbody>
</tbody>
Specification/ Condition:
Item | Value 1 | Value 2 |
Apples | < 15 | < 40 |
Oranges | 0-10 | 15-25 |
Bananas | < 10 | < 30 |
Mango | < 10 | < 20 |
<tbody>
</tbody>
I would like the cells that do not meet specification turn red.
Thank you!