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...
*correction* The formula I am currently using is =AND($F:$F="Service B",$E:$E<30000). I realized the one above does not have <. I also realize I am only using < and not > as well. I was just trying to get the formula to work before I added the >.