Conditional Formatting Formula - if(and(sumif.....

I'm trying to use the formula option in conditional formatting to determine if the value falls between two different values. I'm using IF(AND(SUMIF(RANGE,CRITERIA,SUM RANGE)>Value A,SUMIF(RANGE,CRITERIA,SUM RANGE)<=Value B)

If this is "True", format new color

Attached is example data set

Hi mmaya, try formula below for condition 1-50 (magenta) and remember change the CF range to B14:B16 instead of just B14

Formula:

Please Login or Register  to view this content.

ps: try do the similar for the other two colors



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Thanks! That worked on the example file I sent but I cant get to work on my real file. It's attached here.

Hi mmaya8, your ranges were different and you'll need to modify the formula accordingly.
Try this CF rules for 2:8 (light purple):

Formula:

Please Login or Register  to view this content.

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

Alvin - thank you so much. It works. Thank you

Thank you for the feedback, you're welcome



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin