SOLVED

Conditional Formatting On Several Differing Words

Copper Contributor

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 

11 Replies

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

 @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

@sging1 

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

Doug_Robbins_Word_MVP_0-1698918951222.png

 

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

 

Screenshot 2023-11-02 100925.png

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

Doug_Robbins_Word_MVP_0-1698920545845.png

 

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

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

@Charles_Kenyon Thank you, never thought of OneDrive. 

@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

best response confirmed by sging1 (Copper Contributor)
Solution

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

Doug_Robbins_Word_MVP_0-1699004547695.png

 

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
1 best response

Accepted Solutions
best response confirmed by sging1 (Copper Contributor)
Solution

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

Doug_Robbins_Word_MVP_0-1699004547695.png

 

View solution in original post