Forum Discussion
Solved
Using Conditional Formatting with two types of data
I am trying to come up with a formula to highlight a cell when it is less than a number and column F = Service B. I have tried this formula "=AND($F:$F="Service B",$E:$E,30000)" but it does not work...
If you are trying to do this to a Table, then you have to do it like this.
=IF(AND($F2="Service B",$E2<30000),1,0)
Then for "Applies to", enter the range you want it to happen to.
Erut313 I thought it worked but I am having issues now. I changed your formula to this, so it would pick up anything greater than 33,000. If you look at the screenshot, row 11 is in red although column f says Service A and the value is not greater than 33000. Row 12 column E is not in red even though column f says Service B and the value is greater than 33,000.
.png){kind=link}