Hi All,

I have a spread sheet that I need to add a function to.

In column B I have a drop down (validation list) consisting of just blank cell and L.
what I need is for each row where the drop down has been set to L, to make the text in the entire row to change to red.

Is this possible and if so how do I do this please?

Thanks jeff