Forum Discussion
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. I am at a loss. I need to highlight numbers in column E that are less than 27,000 but greater than 33,000 and also have the word Service B in column F. I also need to do the same for Service A but at smaller values, which once I get the formula correct for service B I should have no problem creating one for service A.
12 Replies
- =AND((A11>33000),(E12<33000))
Here is an example file with two different examples.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
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.
- *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 >.
.png){kind=link}