I have some data it starts in E5. I added a screen shot too to show how the cells are merged. I am wanting to conditional format column F that is the merged cells to see if it is between L and M values, also merged cells the same 5 rows. I dont know much about conditional formats. I know I can use index or mod but don't know where to put the equation or what to highlight when i put it in. I watched excel magic and am still lost. I had something like =index(F:F,(row()+41)/5))
this is the same =INDEX(F:F,(ROWS($B$4:$B4)-1)/5+ROW($F$9))
Any help would be great.
thanks
this is the same =INDEX(F:F,(ROWS($B$4:$B4)-1)/5+ROW($F$9))
Any help would be great.
thanks
36.81 | 36.83 |
37.05 | |
36.78 | |
36.75 | |
36.75 | |
36.28 | 36.39 |
36.47 | |
36.75 | |
36.22 | |
36.23 | |
24.88 | 24.76 |
24.66 | |
24.78 | |
24.73 | |
24.77 | |
36.02 | 35.92 |
35.89 | |
35.90 | |
35.75 | |
36.05 |