I need to have J29:J215 filled red or K29:K215 filled red if J29:J215 is blank and there is a value in that row (A29 or K29 or Etc...)
I tried conditional will all values that are blank, but all the cells below the rows that I have data get filled. I only need the the fill when the cell in column J doesn't have a value and the rest of the cells in that row do have values.
Below is my spread sheet.
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"></colgroup><tbody>
</tbody>
I tried conditional will all values that are blank, but all the cells below the rows that I have data get filled. I only need the the fill when the cell in column J doesn't have a value and the rest of the cells in that row do have values.
Below is my spread sheet.
A | B | C | D | E | F | G | H | I | J | K | |
28 | Date | SP | Location | Date of Repair | Referral # | Name | Vehicle | Date of Replace | $$$ | ||
29 | 1/1/2018 | RK | NEL | 1/1/2017 | 6549876549 | johnson johnson and | 2018 ford expedition | 12/30/2018 | $250.00 | ||
30 | 2/2/2018 | DR | LV | 12/2/2017 | 321321 | bobb | $220.00 | ||||
31 | 2/5/2018 | RK | NEL | 6/16/2017 | 3213 | hello | $300.00 | ||||
32 | 3/3/2018 | HS | 308 | 12/12/2017 | 32222 | 321321 | 1/2/2019 | $190.00 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"><col style="width: 68px;"></colgroup><tbody>
</tbody>