Forum Discussion
CONDITIONAL FORMATTING BASED ON TEXT
Hallo, i have a worksheet where i keep track of which jobs i follow on which days in range AO1:XX1 there are the names of the jobs, they are not all there yet, i add them as they are assigned to me...
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