I would like to see if there is any function or macro that can do this. I have conditional formatting set up based on drop down selection which highlights cells that should be edited. In my workbook that I am attaching I pointed to those rows.
1. For the "Region1" selection it should be applied OR which means either of those cells edited should both change to whatever color. If Cell E6 is edited or cell F6 both should change color.
2. For the "Unknown Region" all cells have to be edited in order to change color, so here should be applied AND.