Hi Guys,

Hope you are all ok.

I require some help with my limited knowledge of Excel.......I know what I want is physically possible, I just dont know how to implement it. And after hours of staring at the screen on Friday afternoon I gave up.

Basically I want to conditionally format the results my VLOOKUP finds. I work for a mobile phone company and need to report of connections and disconnections and re-activations to accounts.

My VLookup is comparing MPN (mobile phone number) from Sheet 1 to Sheet 2 and returning a result of either DISCONNECTION, Pending Disconnection, Re-activation or connection.

IF(ISNA(VLOOKUP(A2,Sheet2!A2:L348,4,FALSE)),"",VLOOKUP(A2,Sheet2!A1:L348,4,0))

What I want to do is conditionally format this so say the lookup returns ''DISCONNECTION'' i want that returned as a particular colour ie Blue and the same with the other results. The colours are obviously irrelevant.

I know I need to use a formula in conditional formatting..........I just can't work out the formula.

Can anyone help?