Conditional formatting based on data in other columns?

[Greymud]

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!

 

[Fluff]

You could use this formula with CF

=COUNTIFS($E$2:$E$16,E2,$F$2:$F$16,F2,$G$2:$G$16,G2,$H$2:$H$16,H2,$I$2:$I$16,I2,$J$2:$J$16,J2)>1

 

[Fluff]

As CF is volatile I would keep the formula in col S and then use

=countifs(S$2:S$16,S2)>1

and with 365 you could replace the formula in col S with

=CONCAT(E2:J2)

 

[Greymud]

As CF is volatile I would keep the formula in col S and then use

=countifs(S$2:S$16,S2)>1

and with 365 you could replace the formula in col S with

=CONCAT(E2:J2)

What do you mean by volatile?

Also, thanks for the quick reply.

 

[Fluff]

Volatile means that it recalculates whenever Excel recalculates, so can seriously slow down the workbook, especially if you have a large amount of data.

 

[Greymud]

Thanks for all the assistance.

Sorry it took forever to get back here and reply.

 

[Fluff]

You're welcome & thanks for the feedback.