Hi,
I have posted about this previously but it seems to have been forgotten about. So i am bringing my query forward in a new post.
I have a sheet Basic Summary Sheet.xlsx which uses the index and match formulas with the end prospect of conditionally formatting (highlighting red) which values are elevated.
If you look at the second tab 'Formatting' you can see my data which is in the range h7:u13.
This will be pasted in from another data source and so the values are variable.
Then what happens is each of these values are compared to the corresponding value in the range C7:E13.
For example take 'K11' the value pasted is '1.08'
This should be compared to the value '440' - because it is on row 11 and the corresponding header on row 5 (cell k5) is '6%'.
With the help of some other ExcelForum gods i have created a tab 'values' which displays the correct comparison for each cell in the range h7:u13. This seems to work.
However my problem arises when i try and apply this to conditional formatting. You shall see that in tab 'Formatting' Using the formula '=N11>=INDEX(Screening_TableF,,MATCH(INDEX(SOM_BracketF,,COLUMN()-7)+0,Screening_HeaderF,0))' Only appears to work for the top row (row 7). You can see i have tried to apply this to cell N11, but this is not working properly.
Obviously i want this to work for each individual cell in the range E7 : U13
I don't fully understand the formula so any help to resolve this would be greatly appreciated.
Regards,
Dan Gates
Bookmarks