I have 4 columns, A B C D.
- Column A has a designed value.
- Column B has a reviewed value.
- Column C is empty.
- Column D has a formula which returns false if value in column A does not match value in column B. Also, Column D is always hidden.
I need help in highlighting the row or giving some color to column C if D has false in it.