I have 4 merged cells that comprise a dropdown list of companies. The list of companies is coming from sheet 2 which is hidden. I want to highlight the merged cells that shows the company name IF it isn't one specific company.
What I'm running into is that only half of the merged cells are highlighting. I have to select the dropdown twice for all 4 to highlight. Same goes for the opposite. When I select the company I do NOT want highlighted, only half of the highlight goes away, I have to select the company twice. Anyone experience this before? I'm using the following rule:
Giving me only half on or half off.
What I'm running into is that only half of the merged cells are highlighting. I have to select the dropdown twice for all 4 to highlight. Same goes for the opposite. When I select the company I do NOT want highlighted, only half of the highlight goes away, I have to select the company twice. Anyone experience this before? I'm using the following rule:
Giving me only half on or half off.