Nov 01 2023 11:16 AM
Nov 01 2023 11:16 AM
Hi, before I came on here I have tried for hours to get this to work so not being lazy and hope someone can help. I have got it to go to one colour on one word like Respiratory with the If function but I have several, like Pack, Dressings, etc and want it to go to one of several colours dependent on what is shown.
I have tried many variations but Word keeps changing the formulas automatically to things that just don't make sense so hopeing someone will know how to nest a few criteria together.
Much appreciated if
Nov 01 2023 11:34 PM
@sging1 Can you upload a copy of the document or template with full details of the output that you requried so that we can see what you have and provide appropriate assistance.
Nov 02 2023 02:45 AM
@Doug_Robbins_Word_MVP Hi Doug thank you very much for your time. I have a sample ready to upload but I cant seem to find an upload button.
Thank you again
Nov 02 2023 02:56 AM
If you click on Reply, there is a facility to Drag and drop or browse for files to attach
Nov 02 2023 03:10 AM
@Doug_Robbins_Word_MVP Strange, that seems to be missing from mine. This is all I get.
Nov 02 2023 04:27 AM
@Doug_Robbins_Word_MVP I just tried that, the page refreshed and then brought me back to the same place. I just logged in in Chrome incase it was the browser. Strange altogether.
Nov 02 2023 10:15 AM
You can also save it on OneDrive or DropBox and post a share or view link here.
Note that conditional formatting in Word is very different from (and harder than) in Excel.
Nov 02 2023 02:31 PM
@Doug_Robbins_Word_MVP Hi Doug thank you very much for your time. I have copied a link to a One Drive folder below. Hopefully this will work, the data sample is 7 categories, you will see on the spreadsheet the different colour's that I want on the last field on the Word label to turn to so it can easily be identified to clinical staff from a distance. I have tried so many ways to make this work, I get one colour but no more.
Thank you again for your time.
Nov 03 2023 02:43 AMSolution
@sging1 You need to use a series of IF field constructions as shown below and in the attached document
Nov 03 2023 08:09 AM