Hi there,

Im loosing my mind trying to work out how to do the following, if anyone could help I would be grateful.

I have our company telephone accounts and im trying to highlight any numbers that are not on our approved dialling list. What I would like to happen (ideally) would be for a formula to look at the cell next to it and compare it with the approved numbers list, if it doesn’t appear on the list then it would do something to let me know, like put a big red X in the cell (if it could make me a cup of Tea instead that would be better).

Can this even be done? (not the tea thing)