Forum Discussion
Conditional formatting for entire row based on data in another row
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","")
Does this return your expected result?
=IFERROR(INDEX(C$5:C$23,SMALL(IF($F$5:$F$23="yes",ROW($C$5:$C$23)-4),ROW(A1))),"")This is the formula in cell H5. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
You can see the rules for conditional formatting in the attached file.
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","")