Hello - I am not sure if this can be done in an IF statement.
I have an IF statement here =IF(A2=A3, "Yes","No") which checks the value in column A if the value following is the same as the value prior it returns "Yes" otherwise, it returns "No". I need this statement to also be able to highlight the entire row where "Yes" is returned. Can this be done in the same IF statement? or should I add a new column for a new IF looking at just the "Yes"? How can this be written?
Thank you!!
Bookmarks