In the attached, on
Sheet1, there is conditional formatting to test, however, if you type in 15th May in cell K2 it will highlight some cells despite your not wanting to include column K. If you're not going to have dates in those columns that might suffice for you.
The formatting is based on the likes of:
Code:
=(COUNTIF($F$2:$M$4,F2)-COUNTIF($F2:$M2,F2))>0
However, a longer formula can be used which will also exclude columns K and H and is in place on
Sheet1 (2), it's based on the likes of:
Code:
=(COUNTIF($F$2:$G$4,F2)+COUNTIF($I$2:$J$4,F2)+COUNTIF($L$2:$M$4,F2)-COUNTIF($F2:$M2,F2))>0
Even this second one isn't perfect because really I should have done the same (split into 3 areas) the
-COUNTIF($F2:$M2,F2) part! viz.:
Code:
=(COUNTIF($F$2:$G$4,F2)+COUNTIF($I$2:$J$4,F2)+COUNTIF($L$2:$M$4,F2)-COUNTIF($F2:$G2,F2)-COUNTIF($I2:$J2,F2)-COUNTIF($L2:$M2,F2))>0
This third one is NOT in the attached.
Both sheets show the formula used in columns O:V (these ranges can be deleted).