Forum Discussion
Example - Mechanical Inspection using AQL
Hey Everyone, I am looking to create conditional formatting on a range of cells that will populate said cells based off of an AQL table. I have attached the excel file that shows the data and wha...
I'd do that with helper ranges/cells. For the main table
add percents as numbers, not as texts on the top, and on the left low boundary of ranges.
Here
in B1 how we interpret ALL, and in C1 formula
=IFERROR(
--INDEX(TABLE!$D$5:$S$19,
LOOKUP('TAB 1'!$E$3,TABLE!$A$5:$A$19,(ROW(TABLE!$A$5:$A$19)-ROW(TABLE!$C$4))),
MATCH('TAB 1'!$E$5,TABLE!$D$3:$S$3,1)),
'TAB 2'!$B$1)and conditional formatting rule formula as
=(ROW()>ROW($C$2))*(ROW()<=($C$1+ROW($C$2)))It could be combined al together in one formula, but it will be hard to maintain such.
@AnthonyCappuccio don't forget to update the cells the formatting will apply to in case you have a situation when the value is greater than 20.
SergeiBaklan is there a reason why the iferror function should return "Tab2 B1" which has 100,000 as its value?
No reason except that shall be some number to apply formatting. I know nothing about that business and have no idea that ALL could mean on practice.