Conditional Formatting based off of received versus desired

Options

Hello all,

I am trying to format a column based off of another column. I have a column for amount desired and another column for amount received. I just want to make them turn green when they are equivalent. I have read about adding a helper column to make this happen but get stumped at incorporating it. Any advice/help would be appreciated!

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Options

    If your using the symbols
    =if(row@row=row2@row, “Green”,””)

    If your using a helper row and wanting conditional formatting where it says green make it be what ever you want to flag the row. Then use the conditional formatting to look at that column

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!