Hi all,
I have created condition based drop-down lists (Equipment tree for production line) so that if you choose line X, you can only choose from section Y, an so on. Now I want to create a matrix that also is condition based. So if I choose Line X and Section Y, certain cells should get filled with color. This is so whoever uses the matrix can see which points to do a certain task on if they have chosen Line X and section Y.
I got it working for one cell, but I realized it will take forever if I have to do it for every machine section and then every machine system with one =F5="Section_A" for every section and system. I'm thinking there should be a good way to write a IF(OR) code to help me out but I'm new to excel programming so can't figure it out so far. Any ideas?
Best regards
Maudan
I have created condition based drop-down lists (Equipment tree for production line) so that if you choose line X, you can only choose from section Y, an so on. Now I want to create a matrix that also is condition based. So if I choose Line X and Section Y, certain cells should get filled with color. This is so whoever uses the matrix can see which points to do a certain task on if they have chosen Line X and section Y.
I got it working for one cell, but I realized it will take forever if I have to do it for every machine section and then every machine system with one =F5="Section_A" for every section and system. I'm thinking there should be a good way to write a IF(OR) code to help me out but I'm new to excel programming so can't figure it out so far. Any ideas?
Best regards
Maudan
