Not sure what 'that cell' is but maybe

=AND(E$2=$B3,E$2<=$D3,$BC$31,E$2=$BC$3))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"superkopite"
wrote in message
...

Hiya Guys and Gals,

Just a quickie, I need to adapt the following code;

=(E$2=$B3)*(E$2<=$D3) (this defines a set of cells to format)

It is used in a conditional formatting capacity. What I want to do is
add the following.

If BC3 1 then that cell equals the contents of BC3.

I have had a few stabs at it and not been able to get it right.

I hope I have explained myself adequately

Cheers

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile:
http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=514574