Cond form formula
 

Paul,

Select all of the cells which you would like to turn red (hold shift or
control and click). Go "Format" - "Conditional Formatting". Where it says
"Cell Value Is" choose "Formula Is" in the field type [=$B$2 = "Done"]
without brackets. Choose your formatting and click OK

Dan E

"Paul" wrote in message
...
Easy one I'm sure but can't get it right:

I have a table (A1:C4) with a drop down list on each cell
of my B colum.

When I select "Done" from my drop down in B, i would like
that the appropriate line becomes red.

I've tried if b2=''done'' (and formatting the way I want
it) but it does'nt work.

Help me!

Thanks