Forum Discussion
Apply formatting based on previous column value
Please validate your test data. I think a 3 and a 10 are switched (item1, A), and a 9 is missing from the expected output (item2, 3A)
Why would item3, 1A and 1B be red when the 2A and 2B cells are empty?
I gave you the general approach of reporting on things that are not there. You can add on to that by implementing your logic.
The sample data you provided did not cover all possible scenarios. See if you can provide better sample data.
Hi lbendlin
So I have been trying to understand what you sent me and so far got nowhere. Sorry I keep needing more help.
When you say "Add on to that by implementing your own logic" Where would I implement it?
I did try something like this,
| Item | TEST | Score | Phase |
| Item1 | A | 2 | 1 |
| Item1 | A | 8 | 2 |
| Item1 | A | 3 | 10 |
| Item1 | B | 5 | 1 |
| Item1 | B | 8 | 2 |
| Item1 | B | 9 | 3 |
| Item1 | C | 7 | 1 |
| Item1 | C | 8 | 2 |
| Item1 | C | 10 | 3 |
| Item2 | A | 6 | 1 |
| Item2 | B | 6 | 1 |
| Item2 | C | 6 | 1 |
| Item2 | A | 9 | 3 |
| Item3 | A | 9 | 3 |
| Item3 | B | 9 | 3 |
Nothing in phase 3 will be red because there is no phase 4.
Please validate your test data. I think a 3 and a 10 are switched (item1, A), and a 9 is missing from the expected output (item2, 3A)
Why would item3, 1A and 1B be red when the 2A and 2B cells are empty?