Forum Discussion
CONDITIONAL FORMATTING BASED ON TEXT
Does the attached demo return the intended result? The conditional format only applies if the same 'job' occurs at least once in range D5:D370 and in range AO1:XX1. For example "Monday" occurs twice in D5:D370 but not in AO1:XX1 and isn't highlighted.
you can download the file here https://www.dropbox.com/scl/fi/2w6kezy2dbca0insdbzb2/ORE-2024.xlsm?rlkey=wv1fmcmw2f90lk3cg5cvc0knq&dl=0
i gave you the wrong data, sorry, the second range was D5:AE370
The download doesn't work unfortunately. Perhaps the suggestion in the attached file works for you. I've made an example for the entries in cells AO1:AQ1 which requires 3 different rules for conditional formatting if you want different colors for all jobs. If there are 608 different jobs in range AO1:XX1 and you want a different color for each job it requires 608 rules for conditional formatting.
- I was trying to avoi the need for this many rules, or automate their creation.
I'll probably investigate if a vba script can generate a rule when text is added to a cell in a specific interval.
Thank you for your help
