Stallion Motorsports1647545491 Posted January 12, 2017 Report Share Posted January 12, 2017 Excel guys, I have a spreadsheet that I would like to highlight every cell that has the exact same text. Is there an easy way to do this without literally going cell by cell? Tom Quote Link to comment Share on other sites More sharing options...
Supplicium Posted January 12, 2017 Report Share Posted January 12, 2017 http://excel.tips.net/T002671_Highlighting_Cells_Containing_Specific_Text.html NEWER THAN EXCEL 2003: http://excelribbon.tips.net/T006235_Highlighting_Cells_Containing_Specific_Text.html Quote Link to comment Share on other sites More sharing options...
Gergwheel1647545492 Posted January 12, 2017 Report Share Posted January 12, 2017 Super easy to do using Conditional Formatting http://www.accountingweb.com/technology/excel/identifying-duplicate-values-in-an-excel-list Quote Link to comment Share on other sites More sharing options...
Stallion Motorsports1647545491 Posted January 12, 2017 Author Report Share Posted January 12, 2017 Perfect, thanks guys, I really appreciate it. Tom Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.