Highlight entries one list if they appear in an associated list
Posts2Registration dateTuesday August 19, 2014StatusMemberLast seenAugust 19, 2014
Aug 19, 2014 at 12:18 PM
I wish to highlight entries in one list if they appear in an associated list:
I chose to do this by using a modified COUNTIF function, which I had tested as a stand-alone formula [=(COUNTIF((Allocation_Codes_Table),(A8)))] which gave me a count of 1 where appropriate.
So, for Conditional Formatting, I need to check if COUNT=1 to indicate it found one;
so, CondFormat inserts ="((COUNTIF(('Monthly Allocations'!U8:AI53),(A15)))=1)" ... HOWEVER, it does embolden the cell !!