These are random cells for example A2, B7, C6, D12 etcWhat do you mean "NOT in a range"?
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | |||||||||
2 | 2 | ||||||||
3 | |||||||||
4 | |||||||||
5 | |||||||||
6 | 5 | ||||||||
7 | |||||||||
8 | 3 | ||||||||
9 | |||||||||
10 | |||||||||
11 | 1 | ||||||||
12 | |||||||||
13 | |||||||||
Sheet3 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A1:Z100 | Expression | =AND(A1<>"",A1=MIN($A$1:$Z$100)) | text | YES |
A1:Z100 | Expression | =AND(A1<>"",A1=MAX($A$1:$Z$100)) | text | YES |
23 09 08.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | 65 | 21 | 33 | 57 | 80 | ||
2 | 51 | 45 | 10 | 95 | 17 | ||
3 | 17 | 73 | 95 | 61 | 67 | ||
4 | 62 | 22 | 13 | 50 | 14 | ||
5 | 20 | 49 | 49 | 93 | 85 | ||
6 | 20 | 62 | 97 | 88 | 36 | ||
7 | 63 | 96 | 77 | 42 | 46 | ||
8 | 45 | 41 | 86 | 44 | 15 | ||
9 | 12 | 71 | 18 | 67 | 54 | ||
10 | 46 | 50 | 63 | 61 | 28 | ||
11 | 37 | 98 | 31 | 97 | 96 | ||
12 | 54 | 92 | 72 | 72 | 44 | ||
CF MAX MIN |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
D12,B7,C6,A2 | Expression | =A2=MIN($A$2,$B$7,$C$6,$D$12) | text | NO |
D12,B7,C6,A2 | Expression | =A2=MAX($A$2,$B$7,$C$6,$D$12) | text | NO |
You'd still need to specify the range the CF applies to (the 'boundary') for the random cells. The demo below uses the range A1:Z100.
Book1
A B C D E F G 1 2 2 3 4 5 6 5 7 8 3 9 10 11 1 12 13 Sheet3
Cells with Conditional Formatting Cell Condition Cell Format Stop If True A1:Z100 Expression =AND(A1<>"",A1=MIN($A$1:$Z$100)) text YES A1:Z100 Expression =AND(A1<>"",A1=MAX($A$1:$Z$100)) text YES
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
E | F | G | H | I | J | K | |||
2 | |||||||||
3 | Amount | Amount | Amount | Amount | |||||
4 | 1,000,000 | 310,500 | 960,000 | 260,000 | |||||
5 | |||||||||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
E4,G4,I4,K4 | Expression | =AND(E4<>"",E4=MAX($E$4,$G$4,$I$4,$K$4)) | text | YES |
E4,G4,I4,K4 | Expression | =AND(E4<>"",E4=MIN($E$4,$G$4,$I$4,$K$4)) | text | YES |