auto change font colour of a row when using dropdown

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

You can use conditional formatting to do this. Highlight all the cells to be affected, then click Conditional Formatting | New Rule | Use a Formula ..., then put this formula in the box:

=$B2="L"

(NOTE: this assumes that row 2 is the first highlighted row - change the 2 if different)

Then click on the Format button, choose the Color drop-down and click on Red. Then you can OK your way out and Excel will automatically adjust the formulae to suit the cells you had highlighted.

Hope this helps.

Pete

Hi Pete_UK,

Thanks for the reply, it worked perfectly. Could this also work with multiple items in a list and work on several pages all refering to a list on the first page pleasse?

Cheers Jeff

Hi FDibbins,

Thanks for your reply, I am using 2007 (I forgot to change that on my profile :s) does that mean I'm still limited to ref the same sheet?

Thanks Jeff