Spreadsheet: 89863d1289587846-conditional-formatting-coloring-of-white-is-needed-based-on-the-previous-cell-value-white_previous_current
Sheet: Sheet1

 |  | INPUT
 |  | Grouping Level | Type of Entry | No. of Lines | Journal Entry Number | Account Name
 |  | Entry | NST | 3 | 12345
 |  | Line | NST | 2 | 23423 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 54 | 21413
 |  | Entry | NST | 4 | 12345 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 23 | 23423
 |  | Line | NST | 2 | 21413 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 1 | 10509
 |  | Entry | NST | 4 | 12345
 |  | Line | NST | 5 | 23423 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 6 | 12345
 |  | Entry | NST | 72 | 23423
 |  | Line | NST | 23 | 21413
 |  | Line | NST | 4 | 12345
 |  | Entry | NST | 42 | 23423 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 3 | 21413 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 6 | 10704 | test ramya miscellaneous account ramya
 |  | Line | STD | 7 | 12345 | test ramya miscellaneous account ramya
 |  | Line | STD | 3 | 23423 | [NAME]Liability
 |  | Line | STD | 2 | 21413
 |  | Line | STD | 4 | 10704
 |  | Line | STD | 2 | 12345 | other test ramya's other test other
 |  | Line | STD | 2 | 23423
 |  | Entry | STD | 2 | 21413 | This is an other miscellaneous acount satya ramya
 |  | Line | STD | 3 | 12345
 |  | Line | STD | 1 | 23423
 |  | Entry | STD | 5 | 21413 | This is an other miscellaneous acount satya ramya
 |  | Line | STD | 6 | 21413
 |  | Line | STD | 6 | 10703 | This is an other miscellaneous acount satya ramya
 |  | Line | STD | 6 | 12345 | This is an other miscellaneous acount satya ramya
 |  | Entry | STD | 7 | 23423 | test ramya miscellaneous account ramya
 |  | Line | NST | 8 | 21413 | test ramya miscellaneous account ramya
 |  | Line | NST | 8 | 12345 | [NAME]Liability
 |  | Entry | NST | 8 | 23423
 |  |  | so on…
 |  | OUTPUT
 |  | Grouping Level | Type of Entry | No. of Lines | Journal Entry Number | Account Name
 |  | Entry | NST | 3 | 12345
 |  | Line | NST | 2 | 23423 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 54 | 21413
 |  | Entry | NST | 4 | 12345 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 23 | 23423
 |  | Line | NST | 2 | 21413 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 1 | 10509
 |  | Entry | NST | 4 | 12345
 |  | Line | NST | 5 | 23423 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 6 | 12345
 |  | Entry | NST | 72 | 23423
 |  | Line | NST | 23 | 21413
 |  | Line | NST | 4 | 12345
 |  | Entry | NST | 42 | 23423 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 3 | 21413 | This is an other miscellaneous acount satya ramya
 |  | Line | NST | 6 | 10704 | test ramya miscellaneous account ramya
 |  | Line | STD | 7 | 12345 | test ramya miscellaneous account ramya
 |  | Line | STD | 3 | 23423 | [NAME]Liability
 |  | Line | STD | 2 | 21413
 |  | Line | STD | 4 | 10704
 |  | Line | STD | 2 | 12345 | other test ramya's other test other
 |  | Line | STD | 2 | 23423
 |  | Entry | STD | 2 | 21413 | This is an other miscellaneous acount satya ramya
 |  | Line | STD | 3 | 12345
 |  | Line | STD | 1 | 23423
 |  | Entry | STD | 5 | 21413 | This is an other miscellaneous acount satya ramya
 |  | Line | STD | 6 | 21413
 |  | Line | STD | 6 | 10703 | This is an other miscellaneous acount satya ramya
 |  | Line | STD | 6 | 12345 | This is an other miscellaneous acount satya ramya
 |  | Entry | STD | 7 | 23423 | test ramya miscellaneous account ramya
 |  | Line | NST | 8 | 21413 | test ramya miscellaneous account ramya
 |  | Line | NST | 8 | 12345 | [NAME]Liability
 |  | Entry | NST | 8 | 23423
 |  |  | so on…