Hello,
I have build a spreadsheet that takes an asset allocation list (Table A) and compares it to the 'Dynamic list' which is filtered based on which asset class is selected from the dropdown at the top of table 'A'. The ''Dynamic List' is a filtered version of the master list, Table 'B'. The asset allocation info is fed from the work sheet tab. The reason for this is not apparent in the sample I uploaded, but it is an important feature for the main working file I will be applying these changes to. I tried several tricks for a countif & match formula for a condition format formula, but I was unable to get anything to work for the entire Table 'A' table. I removed them to clean up the example file. I suspect there is a complication with having Table 'A' as a spilled row and the 'Dynamic list' being a spilled column.
I would like to fix the conditional formatting currently in place for Table 'A' to highlight asset numbers that match the 'Dynamic List', and changes based on which filter is selected. The built in basic duplicate condition formatting works, but it also highlights blanks which I would like to avoid.
Can anyone of you fantastic folks help clean up the conditional formatting to only highlight direct matches to the dynamic list and ignore blanks?
Thank you!
Bookmarks