I have created dropdowns that triggers conditional formatting of a range of cells. I want to have the conditional formated values within the range selected on the main sheet to be applied to those same values found throughout multiple sheets and have the dropdown list change to reflect the same as the main sheet. Example sheet 1 shows (A6:E6 "steve, jones, 550, pike, jackson") (G6 "BAD") if "steve, jones, 550, pike, jackson" is located on any other sheets, I'd like the conditional format rule applied as well as the dropdown list to change from "GOOD" to "BAD". I've attached a pic to further explain. Thanks in advance to anyone that can help lead me in the right direction.
Bookmarks