Hello!
Basically, I am trying to highlight cells in a large database that match newly entered data (to help select similar previous cases).
Please see screenshots here: http://imgur.com/a/JMSz5
I'm having trouble with one of my formulas (not sure if this is the fault of the conditional formatting highlighting formula or the total column or both) counting blank cells as 1.
You can see that even blank cells are being counted as highlighted matches & the total column as 18 (should be 0).
The conditional formatting applied to the range E5:V11 (scores) is =ABS(E$2-E5)<=$W$2
The formula in W5 to count the number of targets met is =SUMPRODUCT(--(ABS(E5:V5-$E$2:$V$2)<=$W$2)), then copied down.
Ideas on how to remedy? Any help/suggestions would be greatly appreciated!
Cheers!!!
Bookmarks