I need to know if I could "If Colum A not= Colum B" Change Colour in Colum A"

Colum A (10) Colum B(5) then Colum A should be in a colour designated.

Best Answer

  • Colleen Patterson
    Colleen Patterson ✭✭✭✭✭✭
    Answer ✓

    @desmond_Erskine

    The formula that @Andrée Starå also included a ,1) at the end, so format that column as a checkbox where you are writing the formula, in your example Help C

    =IF([Column A]@row <> [Column B]@row, 1)

    You would then be able to configure a conditional formatting rule where if that column is checked to highlight the row.

    Smartsheet Community Champion and Ambassador

    If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!