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 That worked, thank you. What is the reason for putting the 1,0 at the end of the formula?
TheBoss86 The 1 and 0 are to activate the conditional formatting. Please send me a screenshot of the values that you chose. Sometimes the Formula will get messed up and instead of $F2 it will say something like $F124034, Make sure that doesnt say that.