I was hoping to find a way to do a conditional format to highlight differences in rows. I’ll try to explain. I have an excel file with dozens of rows and hundreds of columns. I want to highlight the first time the value changes in each column. In the attached file, cells F4 and M3 would be the only ones highlighted. I haven’t found a way to do this through ‘Find & Select -> Go to Special’ either with Row Differences or Column Differences. I also haven’t found a way to do this via conditional formatting because when I use format painter to apply the format to the entire table, I get crazy results as the copy/pasted format is pointing at unrelated cells. My preference would be to highlight the cell, but I would welcome any solution which mitigates my having to visually scan each column/row to identify changes. Any help is appreciated. Thanks in advance!