software

Hello,
As a user selects from a list, I'm trying to get Excel to color the cell
according to the selection.
As an example:
If the question is quot;Are you hungry?quot;
The choices could be quot;Yesquot;, quot;Noquot;, quot;Not right nowquot;, quot;How long 'til lunch?quot;,
quot;I'm starvingquot;.
I would like the cell to be (say) colored green for quot;Yesquot; and quot;I'm starvingquot;.
I would like the cell to be (say) colored yellow for quot;Not right nowquot; and
quot;How long 'til lunchquot;.
I would like the cell to be (say) colored red for quot;Noquot;.

In CF, I've tried quot;Formula Isquot; and =OR(quot;Yesquot;,quot;I'm starvingquot;)
Also: quot;Cell Value Isquot; and =quot;yesquot; quot;I'm starvingquot;.....
among other unsuccessful attempts.

Any help would be appreciated.

MJ

Hi

It sounds like you have just missed out the cell reference to be tested
Formula Is
= A1 =OR(quot;Yesquot;,quot;I'm starvingquot;)

Change A1 to whatever the correct cell reference is that contains your
answer

--
Regards

Roger Govierquot;M Johnquot; gt; wrote in message
...
gt; Hello,
gt; As a user selects from a list, I'm trying to get Excel to color the
gt; cell
gt; according to the selection.
gt; As an example:
gt; If the question is quot;Are you hungry?quot;
gt; The choices could be quot;Yesquot;, quot;Noquot;, quot;Not right nowquot;, quot;How long 'til
gt; lunch?quot;,
gt; quot;I'm starvingquot;.
gt; I would like the cell to be (say) colored green for quot;Yesquot; and quot;I'm
gt; starvingquot;.
gt; I would like the cell to be (say) colored yellow for quot;Not right nowquot;
gt; and
gt; quot;How long 'til lunchquot;.
gt; I would like the cell to be (say) colored red for quot;Noquot;.
gt;
gt; In CF, I've tried quot;Formula Isquot; and =OR(quot;Yesquot;,quot;I'm starvingquot;)
gt; Also: quot;Cell Value Isquot; and =quot;yesquot; quot;I'm starvingquot;.....
gt; among other unsuccessful attempts.
gt;
gt; Any help would be appreciated.
gt;
gt; MJ
M John wrote:
gt; Hello,
gt; As a user selects from a list, I'm trying to get Excel to color the cell
gt; according to the selection.
gt; As an example:
gt; If the question is quot;Are you hungry?quot;
gt; The choices could be quot;Yesquot;, quot;Noquot;, quot;Not right nowquot;, quot;How long 'til lunch?quot;,
gt; quot;I'm starvingquot;.
gt; I would like the cell to be (say) colored green for quot;Yesquot; and quot;I'm starvingquot;.
gt; I would like the cell to be (say) colored yellow for quot;Not right nowquot; and
gt; quot;How long 'til lunchquot;.
gt; I would like the cell to be (say) colored red for quot;Noquot;.
gt;
gt; In CF, I've tried quot;Formula Isquot; and =OR(quot;Yesquot;,quot;I'm starvingquot;)
gt; Also: quot;Cell Value Isquot; and =quot;yesquot; quot;I'm starvingquot;.....
gt; among other unsuccessful attempts.
gt;
gt; Any help would be appreciated.
gt;
gt; MJUse a formula of

=OR(A1=quot;Yesquot;,A1=quot;I'm starvingquot;)

assuming the data is in the A column and A1 is the activecell when you
go into CF.

Um...that didn't work....I can send you a screen shot if you're interested.....

MJ

quot;Roger Govierquot; wrote:

gt; Hi
gt;
gt; It sounds like you have just missed out the cell reference to be tested
gt; Formula Is
gt; = A1 =OR(quot;Yesquot;,quot;I'm starvingquot;)
gt;
gt; Change A1 to whatever the correct cell reference is that contains your
gt; answer
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;M Johnquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt; As a user selects from a list, I'm trying to get Excel to color the
gt; gt; cell
gt; gt; according to the selection.
gt; gt; As an example:
gt; gt; If the question is quot;Are you hungry?quot;
gt; gt; The choices could be quot;Yesquot;, quot;Noquot;, quot;Not right nowquot;, quot;How long 'til
gt; gt; lunch?quot;,
gt; gt; quot;I'm starvingquot;.
gt; gt; I would like the cell to be (say) colored green for quot;Yesquot; and quot;I'm
gt; gt; starvingquot;.
gt; gt; I would like the cell to be (say) colored yellow for quot;Not right nowquot;
gt; gt; and
gt; gt; quot;How long 'til lunchquot;.
gt; gt; I would like the cell to be (say) colored red for quot;Noquot;.
gt; gt;
gt; gt; In CF, I've tried quot;Formula Isquot; and =OR(quot;Yesquot;,quot;I'm starvingquot;)
gt; gt; Also: quot;Cell Value Isquot; and =quot;yesquot; quot;I'm starvingquot;.....
gt; gt; among other unsuccessful attempts.
gt; gt;
gt; gt; Any help would be appreciated.
gt; gt;
gt; gt; MJ
gt;
gt;
gt;

That worked. Thanks much. Most appreciated.

MJ

quot;Bob Phillipsquot; wrote:

gt; M John wrote:
gt; gt; Hello,
gt; gt; As a user selects from a list, I'm trying to get Excel to color the cell
gt; gt; according to the selection.
gt; gt; As an example:
gt; gt; If the question is quot;Are you hungry?quot;
gt; gt; The choices could be quot;Yesquot;, quot;Noquot;, quot;Not right nowquot;, quot;How long 'til lunch?quot;,
gt; gt; quot;I'm starvingquot;.
gt; gt; I would like the cell to be (say) colored green for quot;Yesquot; and quot;I'm starvingquot;.
gt; gt; I would like the cell to be (say) colored yellow for quot;Not right nowquot; and
gt; gt; quot;How long 'til lunchquot;.
gt; gt; I would like the cell to be (say) colored red for quot;Noquot;.
gt; gt;
gt; gt; In CF, I've tried quot;Formula Isquot; and =OR(quot;Yesquot;,quot;I'm starvingquot;)
gt; gt; Also: quot;Cell Value Isquot; and =quot;yesquot; quot;I'm starvingquot;.....
gt; gt; among other unsuccessful attempts.
gt; gt;
gt; gt; Any help would be appreciated.
gt; gt;
gt; gt; MJ
gt;
gt;
gt; Use a formula of
gt;
gt; =OR(A1=quot;Yesquot;,A1=quot;I'm starvingquot;)
gt;
gt; assuming the data is in the A column and A1 is the activecell when you
gt; go into CF.
gt;

Hi

Sorry, having a totally senior moment then.
That should have been
=OR(A1=quot;Yesquot;,A1=quot;I'm starvingquot;)

--
Regards

Roger Govierquot;M Johnquot; gt; wrote in message
news
gt; Um...that didn't work....I can send you a screen shot if you're
gt; interested.....
gt;
gt; MJ
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; It sounds like you have just missed out the cell reference to be
gt;gt; tested
gt;gt; Formula Is
gt;gt; = A1 =OR(quot;Yesquot;,quot;I'm starvingquot;)
gt;gt;
gt;gt; Change A1 to whatever the correct cell reference is that contains
gt;gt; your
gt;gt; answer
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;M Johnquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello,
gt;gt; gt; As a user selects from a list, I'm trying to get Excel to color the
gt;gt; gt; cell
gt;gt; gt; according to the selection.
gt;gt; gt; As an example:
gt;gt; gt; If the question is quot;Are you hungry?quot;
gt;gt; gt; The choices could be quot;Yesquot;, quot;Noquot;, quot;Not right nowquot;, quot;How long 'til
gt;gt; gt; lunch?quot;,
gt;gt; gt; quot;I'm starvingquot;.
gt;gt; gt; I would like the cell to be (say) colored green for quot;Yesquot; and quot;I'm
gt;gt; gt; starvingquot;.
gt;gt; gt; I would like the cell to be (say) colored yellow for quot;Not right
gt;gt; gt; nowquot;
gt;gt; gt; and
gt;gt; gt; quot;How long 'til lunchquot;.
gt;gt; gt; I would like the cell to be (say) colored red for quot;Noquot;.
gt;gt; gt;
gt;gt; gt; In CF, I've tried quot;Formula Isquot; and =OR(quot;Yesquot;,quot;I'm starvingquot;)
gt;gt; gt; Also: quot;Cell Value Isquot; and =quot;yesquot; quot;I'm starvingquot;.....
gt;gt; gt; among other unsuccessful attempts.
gt;gt; gt;
gt;gt; gt; Any help would be appreciated.
gt;gt; gt;
gt;gt; gt; MJ
gt;gt;
gt;gt;
gt;gt;
Hey, no problem. Solution works...that's my only concern.
Many thanks and much admiration.

MJ

quot;Roger Govierquot; wrote:

gt; Hi
gt;
gt; Sorry, having a totally senior moment then.
gt; That should have been
gt; =OR(A1=quot;Yesquot;,A1=quot;I'm starvingquot;)
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;M Johnquot; gt; wrote in message
gt; news
gt; gt; Um...that didn't work....I can send you a screen shot if you're
gt; gt; interested.....
gt; gt;
gt; gt; MJ
gt; gt;
gt; gt; quot;Roger Govierquot; wrote:
gt; gt;
gt; gt;gt; Hi
gt; gt;gt;
gt; gt;gt; It sounds like you have just missed out the cell reference to be
gt; gt;gt; tested
gt; gt;gt; Formula Is
gt; gt;gt; = A1 =OR(quot;Yesquot;,quot;I'm starvingquot;)
gt; gt;gt;
gt; gt;gt; Change A1 to whatever the correct cell reference is that contains
gt; gt;gt; your
gt; gt;gt; answer
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards
gt; gt;gt;
gt; gt;gt; Roger Govier
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;M Johnquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hello,
gt; gt;gt; gt; As a user selects from a list, I'm trying to get Excel to color the
gt; gt;gt; gt; cell
gt; gt;gt; gt; according to the selection.
gt; gt;gt; gt; As an example:
gt; gt;gt; gt; If the question is quot;Are you hungry?quot;
gt; gt;gt; gt; The choices could be quot;Yesquot;, quot;Noquot;, quot;Not right nowquot;, quot;How long 'til
gt; gt;gt; gt; lunch?quot;,
gt; gt;gt; gt; quot;I'm starvingquot;.
gt; gt;gt; gt; I would like the cell to be (say) colored green for quot;Yesquot; and quot;I'm
gt; gt;gt; gt; starvingquot;.
gt; gt;gt; gt; I would like the cell to be (say) colored yellow for quot;Not right
gt; gt;gt; gt; nowquot;
gt; gt;gt; gt; and
gt; gt;gt; gt; quot;How long 'til lunchquot;.
gt; gt;gt; gt; I would like the cell to be (say) colored red for quot;Noquot;.
gt; gt;gt; gt;
gt; gt;gt; gt; In CF, I've tried quot;Formula Isquot; and =OR(quot;Yesquot;,quot;I'm starvingquot;)
gt; gt;gt; gt; Also: quot;Cell Value Isquot; and =quot;yesquot; quot;I'm starvingquot;.....
gt; gt;gt; gt; among other unsuccessful attempts.
gt; gt;gt; gt;
gt; gt;gt; gt; Any help would be appreciated.
gt; gt;gt; gt;
gt; gt;gt; gt; MJ
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;