Hello
The only data that will be inputted in the cells is either "D" or "N". I would like to highlight cells that follow the conditions below:
Search in column: A and if the value matches - then highlight the cell
The only data that will be inputted in the cells is either "D" or "N". I would like to highlight cells that follow the conditions below:
Search in column: A and if the value matches - then highlight the cell
- IF value = "D" and "D" or
- IF value = "D" and "N" or
- IF value = "D" and the previous cell to it's left's value = "N"
A | B | C | D | |
1 | orange | D | N | |
2 | apple | D | ||
3 | banana | N | N | |
4 | apple | D |
A | B | C | D | |
1 | orange | N | N | |
2 | apple | D | ||
3 | banana | D | D | |
4 | apple | N |
A | B | C | D | |
1 | orange | D | D | |
2 | apple | D | ||
3 | banana | N | N | |
4 | apple | N |