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