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.
Yes, it's applied to everything except the header row like this: =$A$2:$T$101
I've limited my sheet to 100 data rows for now.
I've limited my sheet to 100 data rows for now.
Hard to say without the file. please check my one if you find the difference.
And are you sure you use LEN($R2), not LEN($R$2) ?
I don't see any difference but it doesn't seem to do what I want. I tried the other suggestion on this thread from OliverScheurich and it worked.
Thank you for your assistance.
~DGM~