RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hi, I have already asked this question before and was answered by etaf, but I have one more correction to be made. So I am posting again .
I have figures in column F. I want to color the whole row if the value is unique, i.e., if it is not repeated. If the difference is less than 1 then too it should color the row. The second condition is that the values / text in column B should be the same.
I have figures in column F. I want to color the whole row if the value is unique, i.e., if it is not repeated. If the difference is less than 1 then too it should color the row. The second condition is that the values / text in column B should be the same.
Book4 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
1 | A | 87091.00 | |||||
2 | A | 87091.20 | |||||
3 | B | 7040.00 | |||||
4 | C | 114534.00 | |||||
5 | C | 114534.40 | |||||
6 | D | 275940.00 | |||||
7 | D | 275940.22 | |||||
8 | E | 13650.00 | |||||
9 | E | 13650.50 | |||||
10 | F | 33264.00 | |||||
11 | F | 33264.00 | |||||
12 | G | 34020.00 | |||||
13 | H | 39060.00 | |||||
14 | H | 39060.67 | |||||
15 | I | 68250.00 | |||||
16 | I | 68250.00 | |||||
17 | Z | 68250.00 | |||||
18 | J | 929.00 | |||||
19 | J | 929.25 | |||||
20 | K | 1147.00 | |||||
21 | K | 1147.00 | |||||
22 | L | 1549.00 | |||||
23 | L | 1549.44 | |||||
24 | M | 1549.00 | |||||
25 | M | 1549.00 | |||||
26 | N | 1859.00 | |||||
27 | N | 1859.00 | |||||
28 | O | 2514.00 | |||||
29 | O | 2514.00 | |||||
30 | P | 2514.00 | |||||
31 | P | 2514.14 | |||||
32 | Q | 4026.00 | |||||
33 | Q | 4026.00 | |||||
34 | R | 4956.00 | |||||
35 | R | 4956.00 | |||||
Sheet1 |
Last edited: