Excel for mac highlight row conditioning formating

broken image
broken image

I have the table with some data now so I click on the column header letter, e.g.

broken image

Things wouldīe peachy if it wouldn't go sideways EVERY SINGLE TIME.

To avoid this I've utilized the conditional formatting for duplicates meaning whenever a number shows up again it marks it red so I know it has already been logged. Now, sometimes happens that the same request comes in again a few days later. New one comes in a new row, where I store the name, request number, issue category, etc. I have a very frustrating issue: I have my xlsx what I use as a sort of a tracker to track some requests.