So i attempted [code] =IF(SUMIFS([Amount],[OPERATION],[@OPERATION])=0,"Zero")[code] and it did not work. Whati am trying to accomplish relates only to finding everything in the spreadsheet that = zero and highlight them. Wether it is 1=1 or 1.2.3.=1 in the same Operations. The above examples and statements are different ways i was thinking of how to get to my ending results. My ultimate goal was to create that macro above in that order and need help. I was thinking if you can create a labeler and then in the second eqution and eliminate the first by its results you will be able to pull all amount that tie zero that do not relate to the data that has "1"