Background: I have a worksheet with different unit types. Each unit type has specific dimensions (width(W) x height(H)). Some of the units are entered in as WxH and others HxW. I'm trying to highlight units that have the same square footage but do not have the same dimensions. For example, if if there is a 200'x50' and a 50'x200', they will both have a squarefootage of 10,000. There is no need to highlight this info because I can count them as the same unit type, but I cannot change the sizes to match each other because they are different and I don't want to lose track of that. My problem arises when I have a 100'x100' unit that results in the same, 10,000 sqft. I need to highlight this unit because it is unique and needs to be manually adjusted for further processing. How can I highlight the 100'x100' unit without highlighting the 200'x50' & 50'x200' units?
The best I could figure out is that I probably need to be using the countifs function, but beyond that, I'm clueless. See example attached for additional details. Any help on this would be greatly appreciated. Thanks in advance.
Book2.xlsx
Bookmarks