Cond form formula
Assuming the dropdown is from the Data=Validation or each dropdown is
linked to the cell in column B of that row - in any event, the end result is
the cell in column B of that row will hold the value "done" without quotes.
select the cells with A1:C4 with A1 as the activecell
do Format=Conditional Formatting
change "Cell is" to "Formula is" by selecting in the first dropdown
put in the formula
=$B1="done"
then select format button, pattern and select red.
OK out of the dialogs.
Regards,
Tom Ogilvy
"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
|