Conditional Formatting On Several Differing Words

[sging1]

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.

 Kind regards

Stephen 

Much appreciated if 

[#2]

@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.

[#3]

 @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

Stephen

[#4]

@sging1 

If you click on Reply, there is a facility to Drag and drop or browse for files to attach

[#5]

@Doug_Robbins_Word_MVP Strange, that seems to be missing from mine. This is all I get.

[#6]

@sging1 Click on the "View discussion in a popup" link

[#7]

@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.

[#8]

@sging1 

You can also save it on OneDrive or DropBox and post a share or view link here.

Why a sample file is important for troubleshooting - - - - - - - and how to do it.

Note that conditional formatting in Word is very different from (and harder than) in Excel.

[#9]

@Charles_Kenyon Thank you, never thought of OneDrive. 

[#10]

@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.

Sample Files

[#11 · Accepted solution]

@sging1 You need to use a series of IF field constructions as shown below and in the attached document

[#12]

Thanks' Doug that looks spot on. I did something similar but couldn't get that to work but I can see some slight differences on yours so I will try this on my main label and will update on how I get on.

Really appreciate your time on this.

Stephen