hey guys, new here.. i did some searching and cannot find what im trying to do. starting to think its not possible.
i have a sheet, with multiple pieces of equipment at work (excavators, loaders, dozers, etc). each type of machine has multiple drop dwn lists in a column. on sheet 2 (equipment), are the lists of all the gear. im looking for a formula on sheet 1 (projects) where for example, under LARGE EXCAVATOR, I pick "10-321 / LB 330 LS". once i pick it under the first drop down, i would like it to strikethrough on sheet 2. then i move on to the second drop down on the projects sheet under LARGE EXCAVATOR. now i pick "10-360 / CAT 336". now i would like that piece of gear to strike through on equipment sheet 2. basically thye end game is that when any given piece of gear on sheet one is picked from any drop down list, that it is checked off on sheet 2. this will just make things easier for me when i need to know if we have iron available or if its already on a specific job.
the only thing so far that has worked for me is selecting the list, under conditional formatting, new rule, format only cells that contain, selecting the cell value to equal to, selecting my 1st drop down list on sheet 1, formatting with strikethrough. this way works for me but would take forever to format every cell, and i cannot figure out how to copy that condition to every drop down list on sheet 1.
i attached the file im working with right now, ive been struggling with this for a couple days and hope to find some input.
thanks
Bookmarks