I have a worksheet with data in columns E - J that I want to use to highlight duplicate values in column B.
What I have so far is in column S a formula of =E2&F2&G2&H2&I2&J2 and column S has conditional formatting to highlight duplicates. It's not elegant, but functional. Column B is a list of dates. I'd like to have that column highlight based on the same data, but without having that extra column. I'm not sure it's possible.
Thanks for any guidance!
What I have so far is in column S a formula of =E2&F2&G2&H2&I2&J2 and column S has conditional formatting to highlight duplicates. It's not elegant, but functional. Column B is a list of dates. I'd like to have that column highlight based on the same data, but without having that extra column. I'm not sure it's possible.
Thanks for any guidance!