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...
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.
.png){kind=link}