Forum Discussion
Solved
Conditional formatting for entire row based on data in another row
Hello everyone I have trouble finding a formula or condition, that will solve my issue. Currently i have a file containing numbers, if the 2 previous numbers are equal to the 3rd number, then "...
You are welcome. In cell J13253 i've entered this formula and draged across column J.
=IF(OR(I13253="yes",OFFSET(I13253,1,0)="yes",OFFSET(I13253,2,0)="yes"),"X","")
That works perfectly, thank you.
Is it possible for me to add a "X" in column J an all marked with a colour?
Is it possible for me to add a "X" in column J an all marked with a colour?
You are welcome. In cell J13253 i've entered this formula and draged across column J.
=IF(OR(I13253="yes",OFFSET(I13253,1,0)="yes",OFFSET(I13253,2,0)="yes"),"X","")- Thank you for both solutions, helped a lot!