Colour the Result of a formula

[Bucklebery]

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

 

[Sue Mosher [MVP-Outlook]]

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]

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

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

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

 

[Sue Mosher [MVP-Outlook]]

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

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

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.

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

 

[Bucklebery]

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

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

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

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.

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

 

[Sue Mosher [MVP-Outlook]]

What kind of form is it -- contact, message?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

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

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"

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


:

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.

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

 

[Bucklebery]

Hi Sue, - Its a Contact Form.

What kind of form is it -- contact, message?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

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

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"

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


:

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.


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

 

[Sue Mosher [MVP-Outlook]]

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

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



:

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"

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


:

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.


message
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

 

[Bucklebery]

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

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

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



:

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"


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


:

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.


message
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

 

[Sue Mosher [MVP-Outlook]]

You asked:

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

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

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.

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



:

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"


message
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


:

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.


message
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?

 

[Bucklebery]

Thanks: So to conclude you agree that a contact canot be "Conditionally
highlghted in red as previously described but as an alternative a contact can
be flageed via a fomula with the mentioned proviso.

You asked:

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

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

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.

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



:

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"


message
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


:

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.


message
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?

 

[Sue Mosher [MVP-Outlook]]

Yes, I thought that's what I said. YOu did try it yourself, didn't you?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Thanks: So to conclude you agree that a contact canot be "Conditionally
highlghted in red as previously described but as an alternative a contact
can
be flageed via a fomula with the mentioned proviso.

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.

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

:

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.

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



:

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"


message
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


:

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.


message
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?