Hi, thanks to Sue I now have a fomula that works!

Question:If I want to conditionally highlight the "No answers" in red on the
Table view how on earth do I do that? Or wou ldit be earier to "Red Flag" it?

Many thanks

Ian

View | [Arrange By] | Current View | Customize Current View | Automatic
Formatting -- I don't know if it will work with a formula field; I suspect
not.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Bucklebery" <(E-Mail Removed)> wrote in message
news:15C158F2-227C-40B6-8C04-(E-Mail Removed)...
> Hi, thanks to Sue I now have a fomula that works!
>
> Question:If I want to conditionally highlight the "No answers" in red on
> the
> Table view how on earth do I do that? Or wou ldit be earier to "Red Flag"
> it?
>
> Many thanks
>
> Ian

You are right it doesn't appear to work.

I put the selection :"Active In Small Groups contains True" in the filter
and it highlighted all of the contacts in view not just the ones with "No" .
I also tired with "Yes" just in case - but same result.

So can I auto flag based on the field?

Thanks


"Sue Mosher [MVP-Outlook]" wrote:

> View | [Arrange By] | Current View | Customize Current View | Automatic
> Formatting -- I don't know if it will work with a formula field; I suspect
> not.
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Bucklebery" <(E-Mail Removed)> wrote in message
> news:15C158F2-227C-40B6-8C04-(E-Mail Removed)...
> > Hi, thanks to Sue I now have a fomula that works!
> >
> > Question:If I want to conditionally highlight the "No answers" in red on
> > the
> > Table view how on earth do I do that? Or wou ldit be earier to "Red Flag"
> > it?
> >
> > Many thanks
> >
> > Ian
>
>
>

From your results, it sounds like you can't use automatic formatting with a
formula field.

I don't know what you mean by "auto flag"

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Bucklebery" <(E-Mail Removed)> wrote in message
news:10CB55BB-3A9D-4D0A-8E63-(E-Mail Removed)...
> You are right it doesn't appear to work.
>
> I put the selection :"Active In Small Groups contains True" in the filter
> and it highlighted all of the contacts in view not just the ones with "No"
> .
> I also tired with "Yes" just in case - but same result.
>
> So can I auto flag based on the field?
>
> Thanks
>
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> View | [Arrange By] | Current View | Customize Current View | Automatic
>> Formatting -- I don't know if it will work with a formula field; I
>> suspect
>> not.

>>
>> "Bucklebery" <(E-Mail Removed)> wrote in message
>> news:15C158F2-227C-40B6-8C04-(E-Mail Removed)...
>> > Hi, thanks to Sue I now have a fomula that works!
>> >
>> > Question:If I want to conditionally highlight the "No answers" in red
>> > on
>> > the
>> > Table view how on earth do I do that? Or wou ldit be earier to "Red
>> > Flag"
>> > it?
>> >
>> > Many thanks
>> >
>> > Ian
>>
>>
>>

The field is defined as a text field.(It says in Type and Format [Text] and
[Text]. It has 2 possible value as defined by a formula:

IIf( [SG1Active] = True Or [SG2Active] = True Or [SG3Active] =
True,"Yes","No")

Now for the formatting: I used the condition "Active In Small Groups is
(exactly) True"

Then use RED 8pt Tahoma. The result was they were all red whether I tested
for True or False, Yes or No.

Re the Fag - I wondered if there was another way of achiveing this "highlt
effect " by testing if the condition was false and then placing a red flag by
those items that met the condition?


Thanks foryour Help Sue! - Ian



"Sue Mosher [MVP-Outlook]" wrote:

> From your results, it sounds like you can't use automatic formatting with a
> formula field.
>
> I don't know what you mean by "auto flag"
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Bucklebery" <(E-Mail Removed)> wrote in message
> news:10CB55BB-3A9D-4D0A-8E63-(E-Mail Removed)...
> > You are right it doesn't appear to work.
> >
> > I put the selection :"Active In Small Groups contains True" in the filter
> > and it highlighted all of the contacts in view not just the ones with "No"
> > .
> > I also tired with "Yes" just in case - but same result.
> >
> > So can I auto flag based on the field?
> >
> > Thanks
> >
> >
> > "Sue Mosher [MVP-Outlook]" wrote:
> >
> >> View | [Arrange By] | Current View | Customize Current View | Automatic
> >> Formatting -- I don't know if it will work with a formula field; I
> >> suspect
> >> not.
>
> >>
> >> "Bucklebery" <(E-Mail Removed)> wrote in message
> >> news:15C158F2-227C-40B6-8C04-(E-Mail Removed)...
> >> > Hi, thanks to Sue I now have a fomula that works!
> >> >
> >> > Question:If I want to conditionally highlight the "No answers" in red
> >> > on
> >> > the
> >> > Table view how on earth do I do that? Or wou ldit be earier to "Red
> >> > Flag"
> >> > it?
> >> >
> >> > Many thanks
> >> >
> >> > Ian
> >>
> >>
> >>
>
>
>

What kind of form is it -- contact, message?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Bucklebery" <(E-Mail Removed)> wrote in message
news:4BE35968-520A-4AFC-95B5-(E-Mail Removed)...
> The field is defined as a text field.(It says in Type and Format [Text]
> and
> [Text]. It has 2 possible value as defined by a formula:
>
> IIf( [SG1Active] = True Or [SG2Active] = True Or [SG3Active] =
> True,"Yes","No")
>
> Now for the formatting: I used the condition "Active In Small Groups is
> (exactly) True"
>
> Then use RED 8pt Tahoma. The result was they were all red whether I tested
> for True or False, Yes or No.
>
> Re the Fag - I wondered if there was another way of achiveing this "highlt
> effect " by testing if the condition was false and then placing a red flag
> by
> those items that met the condition?
>
>
> Thanks foryour Help Sue! - Ian
>
>
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> From your results, it sounds like you can't use automatic formatting with
>> a
>> formula field.
>>
>> I don't know what you mean by "auto flag"

>>
>> "Bucklebery" <(E-Mail Removed)> wrote in message
>> news:10CB55BB-3A9D-4D0A-8E63-(E-Mail Removed)...
>> > You are right it doesn't appear to work.
>> >
>> > I put the selection :"Active In Small Groups contains True" in the
>> > filter
>> > and it highlighted all of the contacts in view not just the ones with
>> > "No"
>> > .
>> > I also tired with "Yes" just in case - but same result.
>> >
>> > So can I auto flag based on the field?
>> >
>> > Thanks
>> >
>> >
>> > "Sue Mosher [MVP-Outlook]" wrote:
>> >
>> >> View | [Arrange By] | Current View | Customize Current View |
>> >> Automatic
>> >> Formatting -- I don't know if it will work with a formula field; I
>> >> suspect
>> >> not.
>>
>> >>
>> >> "Bucklebery" <(E-Mail Removed)> wrote in message
>> >> news:15C158F2-227C-40B6-8C04-(E-Mail Removed)...
>> >> > Hi, thanks to Sue I now have a fomula that works!
>> >> >
>> >> > Question:If I want to conditionally highlight the "No answers" in
>> >> > red
>> >> > on
>> >> > the
>> >> > Table view how on earth do I do that? Or wou ldit be earier to "Red
>> >> > Flag"
>> >> > it?
>> >> >
>> >> > Many thanks
>> >> >
>> >> > Ian
>> >>
>> >>
>> >>
>>
>>
>>

Hi Sue, - Its a Contact Form.

"Sue Mosher [MVP-Outlook]" wrote:

> What kind of form is it -- contact, message?
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Bucklebery" <(E-Mail Removed)> wrote in message
> news:4BE35968-520A-4AFC-95B5-(E-Mail Removed)...
> > The field is defined as a text field.(It says in Type and Format [Text]
> > and
> > [Text]. It has 2 possible value as defined by a formula:
> >
> > IIf( [SG1Active] = True Or [SG2Active] = True Or [SG3Active] =
> > True,"Yes","No")
> >
> > Now for the formatting: I used the condition "Active In Small Groups is
> > (exactly) True"
> >
> > Then use RED 8pt Tahoma. The result was they were all red whether I tested
> > for True or False, Yes or No.
> >
> > Re the Fag - I wondered if there was another way of achiveing this "highlt
> > effect " by testing if the condition was false and then placing a red flag
> > by
> > those items that met the condition?
> >
> >
> > Thanks foryour Help Sue! - Ian
> >
> >
> >
> > "Sue Mosher [MVP-Outlook]" wrote:
> >
> >> From your results, it sounds like you can't use automatic formatting with
> >> a
> >> formula field.
> >>
> >> I don't know what you mean by "auto flag"
>
> >>
> >> "Bucklebery" <(E-Mail Removed)> wrote in message
> >> news:10CB55BB-3A9D-4D0A-8E63-(E-Mail Removed)...
> >> > You are right it doesn't appear to work.
> >> >
> >> > I put the selection :"Active In Small Groups contains True" in the
> >> > filter
> >> > and it highlighted all of the contacts in view not just the ones with
> >> > "No"
> >> > .
> >> > I also tired with "Yes" just in case - but same result.
> >> >
> >> > So can I auto flag based on the field?
> >> >
> >> > Thanks
> >> >
> >> >
> >> > "Sue Mosher [MVP-Outlook]" wrote:
> >> >
> >> >> View | [Arrange By] | Current View | Customize Current View |
> >> >> Automatic
> >> >> Formatting -- I don't know if it will work with a formula field; I
> >> >> suspect
> >> >> not.
> >>
> >> >>
> >> >> "Bucklebery" <(E-Mail Removed)> wrote in message
> >> >> news:15C158F2-227C-40B6-8C04-(E-Mail Removed)...
> >> >> > Hi, thanks to Sue I now have a fomula that works!
> >> >> >
> >> >> > Question:If I want to conditionally highlight the "No answers" in
> >> >> > red
> >> >> > on
> >> >> > the
> >> >> > Table view how on earth do I do that? Or wou ldit be earier to "Red
> >> >> > Flag"
> >> >> > it?
> >> >> >
> >> >> > Many thanks
> >> >> >
> >> >> > Ian
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Yes, that would work. If the significant value from your custom field is
"Yes" (the string), then the formula for the Flag Status field would need to
be:

IIF([Some Field] = "Yes", 2, 0)

Note that using a formula to set the flag status will make it impossible to
flag the contacts manually.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Bucklebery" <(E-Mail Removed)> wrote in message
news:EDEFBD48-0161-4098-BBA8-(E-Mail Removed)...
> Hi Sue, - Its a Contact Form.
>

>> > The field is defined as a text field.(It says in Type and Format [Text]
>> > and
>> > [Text]. It has 2 possible value as defined by a formula:
>> >
>> > IIf( [SG1Active] = True Or [SG2Active] = True Or [SG3Active] =
>> > True,"Yes","No")
>> >
>> > Now for the formatting: I used the condition "Active In Small Groups is
>> > (exactly) True"
>> >
>> > Then use RED 8pt Tahoma. The result was they were all red whether I
>> > tested
>> > for True or False, Yes or No.
>> >
>> > Re the Fag - I wondered if there was another way of achiveing this
>> > "highlt
>> > effect " by testing if the condition was false and then placing a red
>> > flag
>> > by
>> > those items that met the condition?
>> >
>> >
>> > Thanks foryour Help Sue! - Ian
>> >
>> >
>> >
>> > "Sue Mosher [MVP-Outlook]" wrote:
>> >
>> >> From your results, it sounds like you can't use automatic formatting
>> >> with
>> >> a
>> >> formula field.
>> >>
>> >> I don't know what you mean by "auto flag"
>>
>> >>
>> >> "Bucklebery" <(E-Mail Removed)> wrote in message
>> >> news:10CB55BB-3A9D-4D0A-8E63-(E-Mail Removed)...
>> >> > You are right it doesn't appear to work.
>> >> >
>> >> > I put the selection :"Active In Small Groups contains True" in the
>> >> > filter
>> >> > and it highlighted all of the contacts in view not just the ones
>> >> > with
>> >> > "No"
>> >> > .
>> >> > I also tired with "Yes" just in case - but same result.
>> >> >
>> >> > So can I auto flag based on the field?
>> >> >
>> >> > Thanks
>> >> >
>> >> >
>> >> > "Sue Mosher [MVP-Outlook]" wrote:
>> >> >
>> >> >> View | [Arrange By] | Current View | Customize Current View |
>> >> >> Automatic
>> >> >> Formatting -- I don't know if it will work with a formula field; I
>> >> >> suspect
>> >> >> not.
>> >>
>> >> >>
>> >> >> "Bucklebery" <(E-Mail Removed)> wrote in
>> >> >> message
>> >> >> news:15C158F2-227C-40B6-8C04-(E-Mail Removed)...
>> >> >> > Hi, thanks to Sue I now have a fomula that works!
>> >> >> >
>> >> >> > Question:If I want to conditionally highlight the "No answers" in
>> >> >> > red
>> >> >> > on
>> >> >> > the
>> >> >> > Table view how on earth do I do that? Or wou ldit be earier to
>> >> >> > "Red
>> >> >> > Flag"
>> >> >> > it?
>> >> >> >
>> >> >> > Many thanks
>> >> >> >
>> >> >> > Ian
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

When you say "Yes that would work" Are you referring to the formula in my
last post. I ask because it certainly colored them ALL conatcs red in that
view - not just the ones that weren't in a home group. Any idea why?

In one sentence all I want to do is highlight all the folks that aren't in a
home group out of a list that contains a mixtiure of people that are in a
group and some that arent.
Thanks

"Sue Mosher [MVP-Outlook]" wrote:

> Yes, that would work. If the significant value from your custom field is
> "Yes" (the string), then the formula for the Flag Status field would need to
> be:
>
> IIF([Some Field] = "Yes", 2, 0)
>
> Note that using a formula to set the flag status will make it impossible to
> flag the contacts manually.
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Bucklebery" <(E-Mail Removed)> wrote in message
> news:EDEFBD48-0161-4098-BBA8-(E-Mail Removed)...
> > Hi Sue, - Its a Contact Form.
> >
>
> >> > The field is defined as a text field.(It says in Type and Format [Text]
> >> > and
> >> > [Text]. It has 2 possible value as defined by a formula:
> >> >
> >> > IIf( [SG1Active] = True Or [SG2Active] = True Or [SG3Active] =
> >> > True,"Yes","No")
> >> >
> >> > Now for the formatting: I used the condition "Active In Small Groups is
> >> > (exactly) True"
> >> >
> >> > Then use RED 8pt Tahoma. The result was they were all red whether I
> >> > tested
> >> > for True or False, Yes or No.
> >> >
> >> > Re the Fag - I wondered if there was another way of achiveing this
> >> > "highlt
> >> > effect " by testing if the condition was false and then placing a red
> >> > flag
> >> > by
> >> > those items that met the condition?
> >> >
> >> >
> >> > Thanks foryour Help Sue! - Ian
> >> >
> >> >
> >> >
> >> > "Sue Mosher [MVP-Outlook]" wrote:
> >> >
> >> >> From your results, it sounds like you can't use automatic formatting
> >> >> with
> >> >> a
> >> >> formula field.
> >> >>
> >> >> I don't know what you mean by "auto flag"
> >>
> >> >>
> >> >> "Bucklebery" <(E-Mail Removed)> wrote in message
> >> >> news:10CB55BB-3A9D-4D0A-8E63-(E-Mail Removed)...
> >> >> > You are right it doesn't appear to work.
> >> >> >
> >> >> > I put the selection :"Active In Small Groups contains True" in the
> >> >> > filter
> >> >> > and it highlighted all of the contacts in view not just the ones
> >> >> > with
> >> >> > "No"
> >> >> > .
> >> >> > I also tired with "Yes" just in case - but same result.
> >> >> >
> >> >> > So can I auto flag based on the field?
> >> >> >
> >> >> > Thanks
> >> >> >
> >> >> >
> >> >> > "Sue Mosher [MVP-Outlook]" wrote:
> >> >> >
> >> >> >> View | [Arrange By] | Current View | Customize Current View |
> >> >> >> Automatic
> >> >> >> Formatting -- I don't know if it will work with a formula field; I
> >> >> >> suspect
> >> >> >> not.
> >> >>
> >> >> >>
> >> >> >> "Bucklebery" <(E-Mail Removed)> wrote in
> >> >> >> message
> >> >> >> news:15C158F2-227C-40B6-8C04-(E-Mail Removed)...
> >> >> >> > Hi, thanks to Sue I now have a fomula that works!
> >> >> >> >
> >> >> >> > Question:If I want to conditionally highlight the "No answers" in
> >> >> >> > red
> >> >> >> > on
> >> >> >> > the
> >> >> >> > Table view how on earth do I do that? Or wou ldit be earier to
> >> >> >> > "Red
> >> >> >> > Flag"
> >> >> >> > it?
> >> >> >> >
> >> >> >> > Many thanks
> >> >> >> >
> >> >> >> > Ian
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

You asked:

>> >> > Re the Fag - I wondered if there was another way of achiveing this
>> >> > "highlt
>> >> > effect " by testing if the condition was false and then placing a
>> >> > red
>> >> > flag
>> >> > by
>> >> > those items that met the condition?

And I answered that yes, you can use a formula to set the flag, with the
side effect I cited.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Bucklebery" <(E-Mail Removed)> wrote in message
news:B1CF7543-DB66-43EB-A128-(E-Mail Removed)...
> When you say "Yes that would work" Are you referring to the formula in my
> last post. I ask because it certainly colored them ALL conatcs red in
> that
> view - not just the ones that weren't in a home group. Any idea why?
>
> In one sentence all I want to do is highlight all the folks that aren't in
> a
> home group out of a list that contains a mixtiure of people that are in a
> group and some that arent.
> Thanks
>
> "Sue Mosher [MVP-Outlook]" wrote:
>
>> Yes, that would work. If the significant value from your custom field is
>> "Yes" (the string), then the formula for the Flag Status field would need
>> to
>> be:
>>
>> IIF([Some Field] = "Yes", 2, 0)
>>
>> Note that using a formula to set the flag status will make it impossible
>> to
>> flag the contacts manually.

>>
>> "Bucklebery" <(E-Mail Removed)> wrote in message
>> news:EDEFBD48-0161-4098-BBA8-(E-Mail Removed)...
>> > Hi Sue, - Its a Contact Form.
>> >
>>
>> >> > The field is defined as a text field.(It says in Type and Format
>> >> > [Text]
>> >> > and
>> >> > [Text]. It has 2 possible value as defined by a formula:
>> >> >
>> >> > IIf( [SG1Active] = True Or [SG2Active] = True Or [SG3Active] =
>> >> > True,"Yes","No")
>> >> >
>> >> > Now for the formatting: I used the condition "Active In Small Groups
>> >> > is
>> >> > (exactly) True"
>> >> >
>> >> > Then use RED 8pt Tahoma. The result was they were all red whether I
>> >> > tested
>> >> > for True or False, Yes or No.
>> >> >
>> >> > Re the Fag - I wondered if there was another way of achiveing this
>> >> > "highlt
>> >> > effect " by testing if the condition was false and then placing a
>> >> > red
>> >> > flag
>> >> > by
>> >> > those items that met the condition?
>> >> >
>> >> >
>> >> > Thanks foryour Help Sue! - Ian
>> >> >
>> >> >
>> >> >
>> >> > "Sue Mosher [MVP-Outlook]" wrote:
>> >> >
>> >> >> From your results, it sounds like you can't use automatic
>> >> >> formatting
>> >> >> with
>> >> >> a
>> >> >> formula field.
>> >> >>
>> >> >> I don't know what you mean by "auto flag"
>> >>
>> >> >>
>> >> >> "Bucklebery" <(E-Mail Removed)> wrote in
>> >> >> message
>> >> >> news:10CB55BB-3A9D-4D0A-8E63-(E-Mail Removed)...
>> >> >> > You are right it doesn't appear to work.
>> >> >> >
>> >> >> > I put the selection :"Active In Small Groups contains True" in
>> >> >> > the
>> >> >> > filter
>> >> >> > and it highlighted all of the contacts in view not just the ones
>> >> >> > with
>> >> >> > "No"
>> >> >> > .
>> >> >> > I also tired with "Yes" just in case - but same result.
>> >> >> >
>> >> >> > So can I auto flag based on the field?
>> >> >> >
>> >> >> > Thanks
>> >> >> >
>> >> >> >
>> >> >> > "Sue Mosher [MVP-Outlook]" wrote:
>> >> >> >
>> >> >> >> View | [Arrange By] | Current View | Customize Current View |
>> >> >> >> Automatic
>> >> >> >> Formatting -- I don't know if it will work with a formula field;
>> >> >> >> I
>> >> >> >> suspect
>> >> >> >> not.
>> >> >>
>> >> >> >>
>> >> >> >> "Bucklebery" <(E-Mail Removed)> wrote in
>> >> >> >> message
>> >> >> >> news:15C158F2-227C-40B6-8C04-(E-Mail Removed)...
>> >> >> >> > Hi, thanks to Sue I now have a fomula that works!
>> >> >> >> >
>> >> >> >> > Question:If I want to conditionally highlight the "No answers"
>> >> >> >> > in
>> >> >> >> > red
>> >> >> >> > on
>> >> >> >> > the
>> >> >> >> > Table view how on earth do I do that? Or wou ldit be earier to
>> >> >> >> > "Red
>> >> >> >> > Flag"
>> >> >> >> > it?