Conditional Format a cell should the value in teh cell fall between the numbers in two other cells

[damian_r_Home]

Afternoon All.

A Friday afternoon failing on my part...

I require cell G8 to change colour if the value in G8 (which is achieved by the sum =E8-C8) falls between the values which are manually entered into G3 & G4.
G3 will have a positive number (such as 10) while G4 will have a negative number (such as -10).

You help, as always, will be much appreciated.

D

 

[etaf]

select G8
then in conditional formatting
set a formula
=AND( G8 > G4 , G8 < G3 )
if you want to include if equal

then
=AND( G8 > = G4 , G8 < = G3 )

Book6
	A	B	C	D	E	F	G	H
1
2
3		G3 will have a positive number (such as 10) while G4 will have a negative number (such as -10).select G8 then in conditional formatting set a formula =AND( G8 > G4 , G8 < G3 ) if you want to include if equal then =AND( G8 > = G4 , G8 < = G3 )					10
4							-10
5
6
7
8							4
9
10
11
12
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G8	Expression	=AND(G8>=G4,G8<=G3)	text	NO

 

[damian_r_Home]

Thanks etaf, I'll give that a go now and then i can finish work for the week (hopefully)

 

[etaf]

to stop blank cells being included then add G8<>""

Book6
	G
2
3	10
4	-10
5
6
7
8
9
10
11
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G8	Expression	=AND(G8<>"",G8>=G4,G8<=G3)	text	NO