#1
|
|||
|
|||
Conditional formatting - problem with numbers
Hi all,
I'm trying to do conditional formatting in a word document based on student data. I would like residuals under -1 to show up in red and everything else to show up as green. Not sure whether it's being treated as text, but it's just not working properly I've got the following in there. { IF {MERGEFIELD English_Lang_Residual1 } <-1 {MERGEFIELD English_Lang_Residual1 } {MERGEFIELD English_Lang_Residual1 } } Can anyone help please? |
#2
|
||||
|
||||
If -1 is to be red and everything greater in green then
{ MERGEFIELD English_Lang_Residual1 \# "0;0" }
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
Thanks
Thanks for this. Definite progress on where I was.
It's actually everything below -1 (so -2 and under) that should be red. How would this work? |
#4
|
||||
|
||||
{QUOTE{SET Val {MERGEFIELD English_Lang_Residual1}}{=Val+1 \# "{Val};{Val}"}}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting problem | allex011 | Excel | 0 | 07-13-2021 05:31 AM |
Conditional Formatting Problem | keebin | Excel | 1 | 08-30-2016 03:11 AM |
Conditional Formatting problem | EC37 | Excel Programming | 2 | 07-14-2014 01:02 PM |
Problem with Conditional Formatting | wrighty50 | Excel | 11 | 03-25-2012 10:42 AM |
Conditional Formatting Problem Excel 2007 | namedujour | Excel | 6 | 08-04-2011 10:52 AM |