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.
The reference column on the Conduit sheet is R so I opened the Conditional Formatting rule and made the formula: ="LEN($R2)>0". The first row shows '101' which is the correct row from the RESTCO sheet. After applying the rule, nothing gets bolded. What else am I missing?
- 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.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~