Forum Discussion
Excel Formula Help
I need help Highlighting cells in a column based on the number of matches found in another column. Example column A( to highlight) has 3 cells with value "AM" but column B only has 2 with value "AM" ...
With the above setup, Cond. Format. rule with formula that Applies to: =$B$3:$B$12:
=IF(COUNTIF($C$3:$C$12, $B3), COUNTIF($B$3:$B3, $B3) <= COUNTIF($C$3:$C$12, $B3))
this unfortunately did not yield a result for me. I am working with Carrier SCAC codes and trying to use this to find the amount of available trailers in our yard vs how many loads we have going out with that carrier scac, example i have 5 loads for BYLR and only 4 BYLR trailers, then i have 31 loads for HIRS but only have 10 trailers. Thank you for your help
Well, looking at your picture the formula you implemented isn't the one I shared. Carefully look at where the $ are in my formula/sample please
I'm afraid I won't be able to help further without the actual workbook if you can't make it work
(How to upload & share file i.e. with OneDrive)
- My mistake, I will give it another attempt and let you know how it goes, thank you!
- So this worked to an extent, now the problem is it is not finding matches to color based on the top result, would it be possible to add another criteria to highlight the cell nearest to the top of the worksheet , I can send you the worksheet if you'd like.