You can colour the words in the field as required but if you want the
background of the containing cell coloured you are going to need a macro.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
"Martin D" wrote in message
...
worked very well and a little simpler than the previous posting.
Is it possible to change the colour of the formula cell based on the
number
in Risk1:
4 yellow
9 Amber
17 Red
else GREEN
--
Regards
Martin D
"macropod" wrote:
Hi Martin,
Try:
{IF{Risk1} 17 "RANGE" {IF{Risk1} 10 "REPORT" {IF{Risk1} 4 "STOP"
"YES"}}}
If 'Risk1' is a dropdown formfield's bookmark, you'll need to use:
{IF{REF Risk1} 17 "RANGE" {IF{REF Risk1} 10 "REPORT" {IF{REF Risk1} 4
"STOP" "YES"}}}
--
Cheers
macropod
[Microsoft MVP - Word]
"Martin D" wrote in message
...
Pesach,
Not sure that this covers everything, perhaps if I use laymans terms it
may
be clearer.
If Risk1 is less than or equal to 4 then return YES
If Risk1 is greater than 4 and less than 10 return STOP
If Risk1 is greater than 9 and less than 17 return REPORT
If Risk1 is greater than 17 return RANGE
--
Regards
Martin D
"Pesach Shelnitz" wrote:
Hi Martin,
You can get the result that you want by creating nested IF fields as
follows.
{IF {risk1} 1 "{IF {risk1} 4 "YES" "{IF {risk1} 9 "Stop" "{IF
{risk1}
17 "Report" "{IF {risk1} 25 "17-25 range" "Not in any
range"}"}"}"}" ""}
Do not type any of the curly brackets ({}). Create each pair by
selecting
what will be enclosed by them and pressing Ctrl+F9.
Since you didn't give the text for the 17-25 range, I inserted the
text
"17-25 range", but you can replace it by your text.
--
Hope this helps,
Pesach Shelnitz
My Web site: http://makeofficework.com
"Martin D" wrote:
create a formula in a word form.
I have a situation where I ned to provide an auto response based on
the
number d in a bokmarked cell "Risk1"
I have tried the following but it brings up an error
{if { risk1 } ="4""YES"}{if
{risk1}"4""10""Stop"}{if{risk1}"9""17""Report" }
The basic requirement is to provide a different response based on a
number
value in form field bookmark "Risk1" which can range between 1-4,
5-9, 10-16
and 17-25 each of the above ranges need a differing response. Help
please!
--
Regards
Martin D
.