Conditional Format can this be done?

[june131977]

I have a spreadsheet I am working on and I need it to highlight cells depending on data from other cells. Here is an example to make it clearer:
I want cell D4 to highlight yellow if the following conditions are met.

If B4 is greater than C3 and less than E3 turn D4 yellow.
Is it possible to achieve this in excel?

 

[DanteAmor]

Hi and welcome to MrExcel

Try

Dante Amor
	A	B	C	D	E
1
2
3			7		9
4		8
Hoja6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D4	Expression	=AND($B$4>$C$3,$B$4<$E$3)	text	NO

 

[june131977]

Thanks for the super fast response I will give that a try