Do you know if it's possible to use conditional formatting based on the values of 2 columns?
At the moment it seems to be only possible to base conditional formatting on the value of
1 column compared to a hard-coded value.
I want to say 'if col A > col B then turn value in col A red'.
Thanks for any help.
Yes,Since we can do conditional format based on other columns for a column:
Assume you pulled A,B and wants to apply RED color on A
Pull columns A,A,B (A twice) for 2nd A expression something like
case when A>B then 1 else 0 end
On A(1st A) Conditional format
Add Condition->Choose 2nd A
add value 1 and set color RED.
Appreciate if you mark as correct/helpful