Hi -
I'm trying to add some conditional formatting to compare two lists. I've tried the COUNTIF and MATCH functions, but when executed, the formatting applies to the entire list.
I am trying to add the conditional formatting onto cells that are populated completely via VLOOKUP and INDEX/MATCH. I'm thinking there's some sort of error in in how excel is reading these cells. I've made sure they are not formatted as text (they are general). When running the 'check for errors' audit, excel reports that all of my formulas refer to empty cells even though the VLOOKUPs are running correctly.
What am I missing and more importantly how can I get the conditional formatting applied correctly?
Thx.
I'm trying to add some conditional formatting to compare two lists. I've tried the COUNTIF and MATCH functions, but when executed, the formatting applies to the entire list.
I am trying to add the conditional formatting onto cells that are populated completely via VLOOKUP and INDEX/MATCH. I'm thinking there's some sort of error in in how excel is reading these cells. I've made sure they are not formatted as text (they are general). When running the 'check for errors' audit, excel reports that all of my formulas refer to empty cells even though the VLOOKUPs are running correctly.
What am I missing and more importantly how can I get the conditional formatting applied correctly?
Thx.
