Can I do a conditional formatting based on values between two columns ?

09/14/20
Answered - Pending Review

I would like to do a conditional formatting on a column (column A) in such a way that if the value of "column A" is not equal to "column B" then the "column A" should be red.

I dont see any options to compare values between two columns on conditional formatting. Your input is extremely appreciated.

Popular Tags:

Answers

  • MCorbinMCorbin Overachievers

    I would use a "helper" column:

    Helper: =if(ColumnA=ColumnB,1,0)

    Then your conditional formatting would update ColumnA if "Helper" is 0

  • Mary NMary N
    edited 09/16/20

    You can have a look at the video via the link below, I've just found out it. Very clear instruction. Cheers

    https://youtu.be/PzvPxYGasS8

Sign In or Register to comment.