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

Md Mamun

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.

MCorbin

I would use a "helper" column:

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

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

Mary N

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