Wednesday, September 13, 2017

yogi-Conditionally Format Rows Where Cumulative Sum Of Seats For A Team Exceed 10

Google Spreadsheet   Post  #2238

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-13-2017
question by: Apogee Rockets
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/LpigBGxJ5Bo;context-place=mydiscussions
Conditional Formatting for Two Columns
Hello! I'm trying to have a conditional format setting to change the color of the row when column A has ten or more entries, and/or column D has ten or more as a numerical value. Column A is a Team number and column D is a quantity number. This is the formula I have so far, but it's not working: =countif($A:$A,A1&$D:$D, D1)>10

Basically, column A is an identifier and column D is how many that team has. A Team can have multiple rows but can have no more than ten combined. So one row might have Team #1 and quantity of 7, another row has Team #1 again, and quantity of 3, equalling to ten. This is when both rows should highlight.

Thank you for any suggestions!
Screen Shot 2017-09-11 at 4.35.36 PM.png
12 KB

No comments:

Post a Comment