Conditional formatting
Closed
jddsoft
Posts
2
Registration date
Friday October 31, 2014
Status
Member
Last seen
October 31, 2014
-
Oct 31, 2014 at 01:17 PM
jddsoft Posts 2 Registration date Friday October 31, 2014 Status Member Last seen October 31, 2014 - Oct 31, 2014 at 07:07 PM
jddsoft Posts 2 Registration date Friday October 31, 2014 Status Member Last seen October 31, 2014 - Oct 31, 2014 at 07:07 PM
Related:
- Conditional formatting
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Phone formatting software for pc - Download - File management
1 response
jddsoft
Posts
2
Registration date
Friday October 31, 2014
Status
Member
Last seen
October 31, 2014
Oct 31, 2014 at 07:07 PM
Oct 31, 2014 at 07:07 PM
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.
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.
