I have columns e and f that I would like to conditionally format with three different colors.
The difference between the f and e columns will determine which of the colors the cells would get.
ex.
If the difference between cell f7 and e7 is less than or equal to 0.081 then this pair of values will get highlighted red.
If the difference between cell f4 and e4 is between values 0.081 and 5.3 then this pair of values will get highlighted brown.
If the difference between cell f5 and e5 is greater or equal to 5.3 then this pair of values will get highlighted green.
I have attempted to make a difference column g and a formula conditional format but it did not seem to work.
Bookmarks