G
Guest
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 "Are you hungry?"
The choices could be "Yes", "No", "Not right now", "How long 'til lunch?",
"I'm starving".
I would like the cell to be (say) colored green for "Yes" and "I'm starving".
I would like the cell to be (say) colored yellow for "Not right now" and
"How long 'til lunch".
I would like the cell to be (say) colored red for "No".
In CF, I've tried "Formula Is" and =OR("Yes","I'm starving")
Also: "Cell Value Is" and ="yes"+"I'm starving".....
among other unsuccessful attempts.
Any help would be appreciated.
MJ
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 "Are you hungry?"
The choices could be "Yes", "No", "Not right now", "How long 'til lunch?",
"I'm starving".
I would like the cell to be (say) colored green for "Yes" and "I'm starving".
I would like the cell to be (say) colored yellow for "Not right now" and
"How long 'til lunch".
I would like the cell to be (say) colored red for "No".
In CF, I've tried "Formula Is" and =OR("Yes","I'm starving")
Also: "Cell Value Is" and ="yes"+"I'm starving".....
among other unsuccessful attempts.
Any help would be appreciated.
MJ