Forum Discussion
TheBoss86
Oct 16, 2020Copper Contributor
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...
- Oct 16, 2020
TheBoss86 Here you go. I have it as less than, not greater than.
NikolinoDE
Oct 16, 2020Platinum Contributor
=AND((A11>33000),(E12<33000))