Hi There
I need help to highlight cells in Term1 -3 of Table1 separately if the count of value in those cells exceeds the max total set in Table 2. I have attached the tables here. I tried using conditional formatting with the following formula but it didn't seem to work.
For example, if the formula works in Term1, ENT should be highlighted since it appears more than 3 times but GP and Surgery not since they are equal the Max total.
=highlight B3:B13
=countif($B$3:$B$13,$G$3:$G$5)>$H$3:$H$5
Thanking in advance for your help!
Bookmarks