Forum Discussion
Excel
Hi I have a calender which applies formatting to certain cells when applicable. =MATCH(C15,Data!$H$2:$H$110,0)>0 which works fine until two dates collide also if the date falls on a weekend will ...
Hi
Cell H is a list of dates ranging from 1/1/2020 - 1/1/2030
Cell C is also range of dates with the same criteria as per image this changes by 2 drop lists
One is for Months the other is for Years
MarkBeck54 Not sure I follow. Looking at your screenshot and formula, C15 contains the number 26. H2:H110 contains day numbers for a number of Friday's, I presume. The formula looks if there is a number 26 somewhere in H2:H110 and returns an index number (from 1 to 109) if it is found or an #N/A error if not. And then you test if the number is greater than zero. What is it that you actually want to achieve?