Conditional Formatting based off of received versus desired

sdewispelare

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!

Mark.poole

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