Forum Discussion
Tom Gelles
Jun 02, 2018Copper Contributor
Conditional Formatting and Rules for a cell
Is there a way to use conditional formatting & rules in one cell where you can check if the contents of another cell is "ROI" and the number in the current cell is <16 you shade it green, if the numb...
Lorenzo Kim
Sep 24, 2018Bronze Contributor
see this site: https://support.office.com/en-us/article/manage-conditional-formatting-rule-precedence-e09711a3-48df-4bcb-b82c-9d8b8b22463d hope it helps