Conditional Colour Formatting. with multiple values.
Hello.
I’m new here and a pretty basic user of excel. I work in print and use Excel to make Datamerge (DM) files in Adobe InDesign. This is a multiple party process and we’ve had a couple of issues so I’m looking to add a redundancy to make for less issues.
We have a product that changes it’s DM layout depending on which location it’s going to. I have two template sheets that we use and I’m looking to set it up so that a cell changes colour to Red if it’s the wrong location listed.
I.E. I’m using the sheet layout for Locations A-C but I accidentally put in Location D into the sheet I want location D to turn Red and Locations A-C to turn Green. The location Names don’t ever change but I have some 100+ Locations that I need to set it up for.
I’ve gotten it to work for Location D using the conditional Formatting rules with
=Sheet1!$C$2=Sheet 2!$A$2:$A$33 but if I insert Location E it just turns back to white.
Sorry if this is rambling.
Also sorry if the answer is obvious I tried to make it work with Google but couldn’t get it so I turn to th
Hello.I’m new here and a pretty basic user of excel. I work in print and use Excel to make Datamerge (DM) files in Adobe InDesign. This is a multiple party process and we’ve had a couple of issues so I’m looking to add a redundancy to make for less issues. We have a product that changes it’s DM layout depending on which location it’s going to. I have two template sheets that we use and I’m looking to set it up so that a cell changes colour to Red if it’s the wrong location listed. I.E. I’m using the sheet layout for Locations A-C but I accidentally put in Location D into the sheet I want location D to turn Red and Locations A-C to turn Green. The location Names don’t ever change but I have some 100+ Locations that I need to set it up for.I’ve gotten it to work for Location D using the conditional Formatting rules with =Sheet1!$C$2=Sheet 2!$A$2:$A$33 but if I insert Location E it just turns back to white.Sorry if this is rambling. Also sorry if the answer is obvious I tried to make it work with Google but couldn’t get it so I turn to th Read More