Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-24-2021, 05:59 AM
GailH GailH is offline Conditional formatting - problem with numbers Windows 10 Conditional formatting - problem with numbers Office 2019
Novice
Conditional formatting - problem with numbers
 
Join Date: Sep 2021
Posts: 2
GailH is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 09-27-2021, 02:44 AM
gmayor's Avatar
gmayor gmayor is offline Conditional formatting - problem with numbers Windows 10 Conditional formatting - problem with numbers Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #3  
Old 09-27-2021, 04:43 AM
GailH GailH is offline Conditional formatting - problem with numbers Windows 10 Conditional formatting - problem with numbers Office 2019
Novice
Conditional formatting - problem with numbers
 
Join Date: Sep 2021
Posts: 2
GailH is on a distinguished road
Default 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?
Reply With Quote
  #4  
Old 09-27-2021, 07:43 PM
macropod's Avatar
macropod macropod is offline Conditional formatting - problem with numbers Windows 10 Conditional formatting - problem with numbers Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

{QUOTE{SET Val {MERGEFIELD English_Lang_Residual1}}{=Val+1 \# "{Val};{Val}"}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting - problem with numbers Conditional formatting problem allex011 Excel 0 07-13-2021 05:31 AM
Conditional formatting - problem with numbers Conditional Formatting Problem keebin Excel 1 08-30-2016 03:11 AM
Conditional formatting - problem with numbers Conditional Formatting problem EC37 Excel Programming 2 07-14-2014 01:02 PM
Conditional formatting - problem with numbers 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft