title: Excel - format cells in certain rows and with certain values
body: <p>My problem is very specific and I didn't find the answer to it yet (neither on google nor here), so I'll just ask.</p>
  
  <p>I have an Excel sheet where the third column contains text that is either "Contribution" or "Donation" or something else and the cells in columns 4+ contain numbers if it's either of the two.</p>
  
  <p>Example:</p>
  
  <pre>
   ┌───┬───┬──────────────┬──────┬──────┬──────┐
   │...│...│ Contribution │ 120  │ 800  │ 1200 │
   ├───┼───┼──────────────┼──────┼──────┼──────┤
   │...│...│ Donation     │ 30   │ 20   │ 200  │
   ├───┼───┼──────────────┼──────┼──────┼──────┤
   │...│...│ Activity     │ yes  │ no   │ yes  │
   ├───┼───┼──────────────┼──────┼──────┼──────┤
   │...│...│ Donation     │ 50   │ 100  │ 18   │
   ├───┼───┼──────────────┼──────┼──────┼──────┤
   │...│...│ Contribution │ 80   │ 2500 │ 1800 │
   └───┴───┴──────────────┴──────┴──────┴──────┘
  </pre>
  
  <p>I want to add additional formatting that highlights certain cells.</p>
  
  <ul>
   <li>If the row contains "Contribution" and the cell's value is >= 1000</li>
   <li>If the row contains "Donation" and the cell's value is >= 50</li>
  </ul>
  
  <p>But <b>not</b> if the row contains "Contribution" and the cell's value is >= 50 (&amp; &lt; 1000). So in my example above, the highlighted cells would be these:</p>
  
  <pre>
                                        ┌──────┐
    ... ...  Contribution   120    800  │ 1200 │
                                        ├──────┤
    ... ...  Donation       30     20   │ 200  │
                                        └──────┘
    ... ...  Activity       yes    no     yes
                          ┌──────┬──────┐
    ... ...  Donation     │ 50   │ 100  │ 18
                          └──────┼──────┼──────┐
    ... ...  Contribution   80   │ 2500 │ 1800 │
                                 └──────┴──────┘
  </pre>
  
  <p>All I have found so far are ways to either highlight rows containing certain text-strings <b>or</b> highlight cells with a certain value but no combination of the two... is it possible?</p>
  
  <p>Thank you very much in advance!</p>
  
  <p><b>Edit:</b>
  As an attempt to make it easier to follow:
  <a href="https://i.stack.imgur.com/qpLVt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qpLVt.png" alt="Worksheet 1 (excerpt)"></a></p>
  
  <p>On the screenshot above I want to highlight values >= 1000 in columns 4~n of rows 3,6,9,12,... and values >= 50 in columns 4~n of rows 4,7,10,13,... for an infinite number of rows and columns. So on the screenshot row 4 col 4 should be green as well.</p>
  
  <p>If there is a way to check values in rows that are (3n) or (3n+1) instead of checking for "Contribution" or "Donation" that would work in this scenario, too.</p>