Forum Discussion
Solved
Format row if formula returns a result
I have a workbook with 2 sheets that list devices purchased from 2 different companies - RESTCO and Conduit. There are 500 rows on the RESTCO sheet which won't change since I'm now doing business exc...
=NOT(ISNA(INDEX(RESTCO!$A$2:$A$501,MATCH($B2,RESTCO!$B$2:$B$501,0),1)))An alternative could be this rule for conditional formatting.
=NOT(ISNA(INDEX(RESTCO!$A$2:$A$501,MATCH($B2,RESTCO!$B$2:$B$501,0),1)))An alternative could be this rule for conditional formatting.
