Forum Discussion
Conditional Formatting On Several Differing Words
- Nov 03, 2023
sging1 You need to use a series of IF field constructions as shown below and in the attached document
- sging1Nov 02, 2023Copper Contributor
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.
https://1drv.ms/f/s!Ase_7-fWVPmLkNM-RKTQMxCOdR6hgA?e=qk3Zks
- Nov 03, 2023
sging1 You need to use a series of IF field constructions as shown below and in the attached document
- sging1Nov 03, 2023Copper ContributorThanks' 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
- sging1Nov 02, 2023Copper Contributor
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.
- Charles_KenyonNov 02, 2023Bronze Contributor
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.- sging1Nov 02, 2023Copper Contributor
Charles_Kenyon Thank you, never thought of OneDrive.