Select cell D8.
Format/ Conditional Formatting/ Formula Is/
=AND(A8=Sheet2!F7,A8<=Sheet2!H7) if F7 is less than or equal to H7
or
Format/ Conditional Formatting/ Formula Is/
=A8=MEDIAN(Sheet2!F7,A8,Sheet2!H7) more generally
--
David Biddulph

"Seanie" wrote in message
...
I wish to create a conditional format formula that will change the
background colour in a cell to Blue, if the value of another cell is
between to values (which are also detailed)

Cell I want to change is D8 on Sheet1
The dependent cell of D8 is in A8 on Sheet1
The two values which A8 must be between/or equal to is in F7 & H7 on
Sheet2

I just can't get my head around how to construct this

Thanks