Hello,
I hace a worksheet that has many rows of data with 36 columns. I need to
find a way that if two or more columns in that row have matching values, I
can change the background color to red

Here is a example. The numbers are actually formatted as text and not numbers.
A B C D E F G
12 14 16 8 24 8 14 -----Cells B D F G should be red
15 5 6 5 6 2 9 Cells B C D E should be red

Any help would be greatly appreciated.

regards

Chris