00:00This is part two of creating 2D lookup array that looks and operates something like this.
00:05To get your crosshair intersect to work, we have to create two prep cells to capture column and row.
00:11Select cell H1 and use the match function to look for the month of May and return its position in
00:17the lookup array for the month.
00:18And we plus three to get the actual position on the worksheet.
00:22This is going to be our column index for the crosshair intersect highlight.
00:26Next, we'll get the row index.
00:27We'll be using financial element.
00:29We'll repeat the same process and add 5 to obtain the actual position on the worksheet.
00:34This formula will be our row index for highlighting the intersection of the crosshair.
00:38Now to highlight the intersecting cell, we will use the conditional formatting.
00:41Select your data set B5 to J36, then go home style conditional formatting and select new rule.
00:47Then select use a formula and use this formula.
00:50After that, select format.
00:52Make sure you're on a fill tab and select any color that you want.
00:55I'm going to select red and click OK twice.
00:58After that, you're done.
00:59Hey,
00:59I guess should I prefer it?
00:59That's amazing.
00:59and that if I would like it.
00:59I would like you
Comments