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

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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!