Conditional formatting [Closed]

Report
Posts
2
Registration date
Friday October 31, 2014
Status
Member
Last seen
October 31, 2014
-
Posts
2
Registration date
Friday October 31, 2014
Status
Member
Last seen
October 31, 2014
-
Hello,
Would anyone know how to make this work in conditional formatting:
=COUNTIFS(G1:K8,5,A1:E8,">=30")

1 reply

Posts
2
Registration date
Friday October 31, 2014
Status
Member
Last seen
October 31, 2014

Hello again,
here is more details on what I am trying to do. Thank you.

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!