Conditional Formatting

[A Parker]

How do I conditionally format cells, which are NOT in a range. I'm looking to highlight the highest and lowest value in random cells.

 

[kevin9999]

What do you mean "NOT in a range"?

 

[A Parker]

What do you mean "NOT in a range"?

These are random cells for example A2, B7, C6, D12 etc

 

[kevin9999]

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

 

[Peter_SSs]

Welcome to the MrExcel board!

If there could be other numerical values in between, try this.
Whatever cell is mentioned at the beginning of the formulas (A2 for me) must be the active cell when the CF is applied.
(Borders were added manually to help me identify the relevant cells)

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

 

[A Parker]

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

 

[A Parker]

See attached an example.
I want to apply Conditional formatting (highest & lowest value) to the following cells: E4, G4, I4, K4
Is that possible?

 

[kevin9999]

Yes (although that's very different from your original post ) like this:

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

 

[A Parker]

Yep. Terrific Thank you.

 

[kevin9999]

Glad we could help