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","")
OliverScheurich
Perhaps, I'm just stupid, but I can't get it to work.
I'm currently using this for my yes/no calculation.
=IF(C13253=C13251+C13252;"yes";"no")
(Sidenote, I can't get permission to upload pictures, so here I have a screenshot instead)
https://imgur.com/HqwZgHQ
=$I3="yes"This is the rule for conditional formatting that is applied to three different ranges as shown in the screenshot and in the attached file.
In cell I13253 i've entered your formula and draged it across column I.
- That works perfectly, thank you.
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!