Confusion...(conditional formatting)

[nishapurohit]

Thanks to all that replied to my post!!

I was looking to make F2 field a required field, i.e <red>

If E2 = "yes" then make F2 a required field.

I am going to email this spreadsheet to users, if the user select "yes" to question asked in E column, I would like them to provide detailed information in column F.

Does that make sense?

Thank you again for your help! this forum rocks!

[Anne Troy]

Sure. Click on F2. Format-->Conditional Formatting, Formula is:
=IF(E2)="yes"
Tell it to be red fill....
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"nishapurohit" <[email protected]>
wrote in message
news:[email protected]...
>
> Thanks to all that replied to my post!!
>
> I was looking to make F2 field a required field, i.e <red>
>
> If E2 = "yes" then make F2 a required field.
>
> I am going to email this spreadsheet to users, if the user select "yes"
> to question asked in E column, I would like them to provide detailed
> information in column F.
>
> Does that make sense?
>
> Thank you again for your help! this forum rocks!
>
>
> --
> nishapurohit
> ------------------------------------------------------------------------
> nishapurohit's Profile:
> http://www.excelforum.com/member.php...o&userid=30983
> View this thread: http://www.excelforum.com/showthread...hreadid=506552
>

[Bob Phillips]

No need for the IF, just use

=E2="yes"

as that resolves to TRUE or FALSE

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Anne Troy" <[email protected]> wrote in message
news:[email protected]...
> Sure. Click on F2. Format-->Conditional Formatting, Formula is:
> =IF(E2)="yes"
> Tell it to be red fill....
> ************
> Hope it helps!
> Anne Troy
> www.OfficeArticles.com
>
> "nishapurohit" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > Thanks to all that replied to my post!!
> >
> > I was looking to make F2 field a required field, i.e <red>
> >
> > If E2 = "yes" then make F2 a required field.
> >
> > I am going to email this spreadsheet to users, if the user select "yes"
> > to question asked in E column, I would like them to provide detailed
> > information in column F.
> >
> > Does that make sense?
> >
> > Thank you again for your help! this forum rocks!
> >
> >
> > --
> > nishapurohit
> > ------------------------------------------------------------------------
> > nishapurohit's Profile:
> > http://www.excelforum.com/member.php...o&userid=30983
> > View this thread:
http://www.excelforum.com/showthread...hreadid=506552
> >
>
>

[Anne Troy]

Thanks, Bob.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> No need for the IF, just use
>
> =E2="yes"
>
> as that resolves to TRUE or FALSE
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "Anne Troy" <[email protected]> wrote in message
> news:[email protected]...
>> Sure. Click on F2. Format-->Conditional Formatting, Formula is:
>> =IF(E2)="yes"
>> Tell it to be red fill....
>> ************
>> Hope it helps!
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "nishapurohit"
>> <[email protected]>
>> wrote in message
>> news:[email protected]...
>> >
>> > Thanks to all that replied to my post!!
>> >
>> > I was looking to make F2 field a required field, i.e <red>
>> >
>> > If E2 = "yes" then make F2 a required field.
>> >
>> > I am going to email this spreadsheet to users, if the user select "yes"
>> > to question asked in E column, I would like them to provide detailed
>> > information in column F.
>> >
>> > Does that make sense?
>> >
>> > Thank you again for your help! this forum rocks!
>> >
>> >
>> > --
>> > nishapurohit
>> > ------------------------------------------------------------------------
>> > nishapurohit's Profile:
>> > http://www.excelforum.com/member.php...o&userid=30983
>> > View this thread:
> http://www.excelforum.com/showthread...hreadid=506552
>> >
>>
>>
>
>

[Bob Phillips]

You know the pleasure is mine Ma'am,

Bob

"Anne Troy" <[email protected]> wrote in message
news:#[email protected]...
> Thanks, Bob.
> ************
> Hope it helps!
> Anne Troy
> www.OfficeArticles.com
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > No need for the IF, just use
> >
> > =E2="yes"
> >
> > as that resolves to TRUE or FALSE
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "Anne Troy" <[email protected]> wrote in message
> > news:[email protected]...
> >> Sure. Click on F2. Format-->Conditional Formatting, Formula is:
> >> =IF(E2)="yes"
> >> Tell it to be red fill....
> >> ************
> >> Hope it helps!
> >> Anne Troy
> >> www.OfficeArticles.com
> >>
> >> "nishapurohit"
> >> <[email protected]>
> >> wrote in message
> >> news:[email protected]...
> >> >
> >> > Thanks to all that replied to my post!!
> >> >
> >> > I was looking to make F2 field a required field, i.e <red>
> >> >
> >> > If E2 = "yes" then make F2 a required field.
> >> >
> >> > I am going to email this spreadsheet to users, if the user select
"yes"
> >> > to question asked in E column, I would like them to provide detailed
> >> > information in column F.
> >> >
> >> > Does that make sense?
> >> >
> >> > Thank you again for your help! this forum rocks!
> >> >
> >> >
> >> > --
> >> > nishapurohit
> >>
> ------------------------------------------------------------------------
> >> > nishapurohit's Profile:
> >> > http://www.excelforum.com/member.php...o&userid=30983
> >> > View this thread:
> > http://www.excelforum.com/showthread...hreadid=506552
> >> >
> >>
> >>
> >
> >
>
>