Forum Discussion
Conditional Formatting On Several Differing Words
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 b...
sging1 You need to use a series of IF field constructions as shown below and in the attached document
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.
sging1 You need to use a series of IF field constructions as shown below and in the attached document
- 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
