I have attached a test report to show my problem. Basically I know how to do conditional formatting to highlight all cells with the word Total in it but I need to highlight all rows that have a cell with the word total in it. Thanks for suggestions in advance.
Bookmarks