Hello,
Please help me. For some reason I cannot attach my file, so I will try to explain without it.
I need to highlight values in column C that are higher than either column A or B but only if column A or B have values.
Right now, this is my formula and it works partially. It highlights correctly with exception of third line, where my column A is blank. In this case C should not be highlighted because the value is smaller than B.
=OR($C170>$A170,$C170>$B170)
Is there any way to do this?
Example:
A B C
0.5 0.5 1
1 0.75 0.5
2 1
Bookmarks