Hello, I have a quick conditional formatting question.
Consider the data below:
A B C D E F G H I J K L M N
1 6 9 10 22 34 6 4 4 9 6
2 4 6 18 20 32 6 7 4 5 5
3 11 17 18 19 29 3 3 5 4 9 30 2
4 1 2 5 10 27 1 5 3 5 4 31 3
5 5 9 23 27 29 4 4 6 5 9 32 5
6 1 2 4 9 16 2 6 5 5 5 33 1
7 6 7 25 33 34 6 4 1 3 6 34 4
8 22 23 27 33 35 7 7 5 4 4 35 5
This formula: =COUNTIFS(G1:K8,5,A1:E8,">=30") counts how many times a number greater than or equal to 30 from array A1 to E8 falls in the same position as the number 5 in array G6 TO K8. In the case below, the count will be 1 and happens for E2 and the matching 5 in K2.
In this particular case, I would like some help in creating a conditional formatting that would highlight all occurrences of the 5 in the column N.
I hope that this is clear enough. Any help will be greatly appreciated.
Bookmarks