Forum Discussion
Solved
Coloring rows in Excel based on how many criteria are met
I have just gotten into working with the developer tab of Excel, and I need some help. I am trying to find an easier way to color rows on a sheet based on the number of criteria that is met. I could ...
Hi,
that could be like
=((OR(INDIRECT("Table1[@AGE]")>55,INDIRECT("Table1[@CLASS]")<1979))+(INDIRECT("Table1[@GENDER]")="Male")+(OR(INDIRECT("Table1[@STATUS]")="Widowed",INDIRECT("Table1[@STATUS]")="Single"))+(INDIRECT("Table1[@['# OF GIFTS]]")>=5)+(INDIRECT("Table1[@[TOTAL GIFT AMOUNT]]")>=100))=5for first rule, etc
Hi,
that could be like
=((OR(INDIRECT("Table1[@AGE]")>55,INDIRECT("Table1[@CLASS]")<1979))+(INDIRECT("Table1[@GENDER]")="Male")+(OR(INDIRECT("Table1[@STATUS]")="Widowed",INDIRECT("Table1[@STATUS]")="Single"))+(INDIRECT("Table1[@['# OF GIFTS]]")>=5)+(INDIRECT("Table1[@[TOTAL GIFT AMOUNT]]")>=100))=5
for first rule, etc
Perfect, thank you!