I am trying to figure out how to highlight a row or two cells in a row when they do not equal each other. However, I only want them to be highlighted if both cells have a value in them. In the attached example, I do not want rows 72 or 76 to be highlighted since there are not values in column D (estimated costs) or F (Total Committed) but I do want row 81 to highlight Cell D81 and F81 since they are not the same value. Any help would be greatly appreciated!
Bookmarks