T tywlam Apr 23, 2009 #1 How do I locate cells in a range where data is missing or mismatched with other cells in another range? Thanks.
How do I locate cells in a range where data is missing or mismatched with other cells in another range? Thanks.
S Stefi Apr 23, 2009 #2 A simple way for that is to highlight mismatching cells via conditional formatting: Top left cell of 1st range being A1 Top left cell of 2nd range being G1 Select 2nd range Formats>conditional formatting>formula: =A1<>G1 Regards, Stefi „tywlam†ezt Ãrta:
A simple way for that is to highlight mismatching cells via conditional formatting: Top left cell of 1st range being A1 Top left cell of 2nd range being G1 Select 2nd range Formats>conditional formatting>formula: =A1<>G1 Regards, Stefi „tywlam†ezt Ãrta:
T tywlam Apr 23, 2009 #3 Thank you. Stefi said: A simple way for that is to highlight mismatching cells via conditional formatting: Top left cell of 1st range being A1 Top left cell of 2nd range being G1 Select 2nd range Formats>conditional formatting>formula: =A1<>G1 Regards, Stefi „tywlam†ezt Ãrta: Click to expand...
Thank you. Stefi said: A simple way for that is to highlight mismatching cells via conditional formatting: Top left cell of 1st range being A1 Top left cell of 2nd range being G1 Select 2nd range Formats>conditional formatting>formula: =A1<>G1 Regards, Stefi „tywlam†ezt Ãrta: Click to expand...
S Stefi Apr 23, 2009 #4 You are welcome! Thanks for the feedback! Clicking the YES button will be appreciated. Stefi „tywlam†ezt Ãrta:
You are welcome! Thanks for the feedback! Clicking the YES button will be appreciated. Stefi „tywlam†ezt Ãrta:
