I have a spread sheet with dollar values from cell L3 to L148 skipping every second cell(L3,L5,L6 etc) with cell L154 being the total of all the cell. If any of these cell doesn't have a dollar value the cell is highlighted. Because I can't see the entire page at once if I only look at the total I might not see if one cell is blank and highlighted. Is there a way to format so that if any of the cells from L3 to L148 don't have a dollar value cell L154 with the totals would be highlighted. Just to note that even though these cells might not have a dollar value they still contain a formula.