iamwaitingforgodot

That's a really ingenious solution. The use of reading ages is a curveball but I see that as it will always be greater than zero it provides a great reliable way to trigger the right condition. Excellent - thank-you!

I can't see it on the booking options...

Hello all, First time poster - long time reader. My background is in Visual Basic and Excel but I am trying for the first time to create an individual report in Word from SIMS with conditional formatting but without VB and am struggling to get the syntax right. Any help appreciated! Essentially there are six aspects on a marksheet that link to curriculum objectives. To save staff workload, they enter an N when an objective has not been met and leave it blank if it has. The report will then list all curriculum objectives and where there is an N it will print the text Not Yet Met. Ideally, it will also then print Met if the cell is blank or contains any other value. I have tried various ways - see below - but cannot get it to work. I would be so grateful if anyone can correct my syntax. For the simple If I have tried - { if <> = "N" "Not Yet Met" } - with spaces as they appear here. I have also tried adding field brackets around the aspect to see if that helped... { if {<>} = "N" "Not Yet Met" } And thinking it might be missing an 'else' I've even tried { if {<>} = "N" "Not Yet Met" "Met" } As well as { if <> = "N" "Not Yet Met" "Met" } Can anyone put me out of my misery? Each version just repeats my code back. Thanks in advance!