gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 675
- Office Version
- 2019
- Platform
- Windows
Hello,
How can I highlight cells if value exists in ALL 3 columns?
conditional formatting??
thx
How can I highlight cells if value exists in ALL 3 columns?
conditional formatting??
thx
Cell Formulas | ||
---|---|---|
Range | Formula | |
AC128:AC131 | AC128 | =IFERROR(INDEX($A$4:$A$33,SMALL(IF(($Q$4:$Q$33>=0.55)*($Q$4:$Q$33<>"")*ISODD(ROW($Q$4:$Q$33)-ROW(Q$4)),ROW($Q$4:$Q$33)-ROW($Q$4)+1),ROWS(AC$128:AC128))),"") |
AD128:AD131 | AD128 | =IFERROR(INDEX($A$4:$A$33,SMALL(IF(($AL$4:$AL$33>=0.6)*($AL$4:$AL$33<>"")*ISODD(ROW($AL$4:$AL$33)-ROW(AL$4)),ROW($AL$4:$AL$33)-ROW($AL$4)+1),ROWS(AD$128:AD128))),"") |
AE128:AE131 | AE128 | =IFERROR(INDEX(A$4:A$33,AGGREGATE(15,6,(ROW(A$4:A$33)-ROW(A$4)+1)/((AM$4:AM$33>=0.6)*(AM$4:AM$33<>"")*ISODD(ROW(A$4:A$33))),ROWS(AE$128:AE128))),"") |
Press CTRL+SHIFT+ENTER to enter array formulas. |