I have a spreadsheet that has a drop down menue.
It can choose 2 options.

Cell p7 is the field it fills. It will either be a 1 or a 2.

I have 2 rows A40 to F41 that will be displayed and have fields B41,
C41, D41,E41 and
F41 that can be completed.

the second row has about the same info but the formatting of the
fields is slightly different.
If cell p7 is a 2 then A41 to F43 are displayed and like the previous
row, cells B43, C43, D43, E43, F43 are fields that can be completed.

I have looked at conditional formatting but cannot find a way to make
this work so that I can still complete these fields depeding on cell
P7.

any sugestions would be helpful
thanks

Mel

What do you mean by "2 rows....are displayed"? What do you want to see when
they are "displayed"? What do you want to see (or not see) when they are
NOT "displayed". Do you mean the rows are hidden and not hidden? HTH Otto
<(E-Mail Removed)> wrote in message
news:ca8b74fd-3e1a-4bd0-a20c-(E-Mail Removed)...
>I have a spreadsheet that has a drop down menue.
> It can choose 2 options.
>
> Cell p7 is the field it fills. It will either be a 1 or a 2.
>
> I have 2 rows A40 to F41 that will be displayed and have fields B41,
> C41, D41,E41 and
> F41 that can be completed.
>
> the second row has about the same info but the formatting of the
> fields is slightly different.
> If cell p7 is a 2 then A41 to F43 are displayed and like the previous
> row, cells B43, C43, D43, E43, F43 are fields that can be completed.
>
> I have looked at conditional formatting but cannot find a way to make
> this work so that I can still complete these fields depeding on cell
> P7.
>
> any sugestions would be helpful
> thanks
>
> Mel