Colour the Result of a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
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



Bucklebery said:
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
Click to expand...
Click to expand...
 
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



Bucklebery said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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



Bucklebery said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
What kind of form is it -- contact, message?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Bucklebery said:
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 said:
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 said:
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.
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Hi Sue, - Its a Contact Form.

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



Bucklebery said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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



Bucklebery said:
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"
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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



Bucklebery said:
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
Click to expand...
Click to expand...
Click to expand...
 
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



Bucklebery said:
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 said:
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 said:
Hi Sue, - Its a Contact Form.
Click to expand...
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?
Click to expand...
Click to expand...
Click to expand...
 
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.

Sue Mosher said:
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



Bucklebery said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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



Bucklebery said:
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.

Sue Mosher said:
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?
Click to expand...

And I answered that yes, you can use a formula to set the flag, with the
side effect I cited.

Bucklebery said:
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.
Click to expand...
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top