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

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

Maybe:

=IF(AND(E$2=$B3,E$2<=$D3,BC31),BC3,0)

HTH
Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=514574

Thanks guys

Niether solution is working but i think this may be my error. I think i
am trying to do the impossible here.

I shall endevour to find another way around it.

Thanks a lot

Kind regards

James


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

James,

I tend to believe that it can't be impossible. Could you not add a little to
explain how it does not work?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"superkopite"
wrote in message
...

Thanks guys

Niether solution is working but i think this may be my error. I think i
am trying to do the impossible here.

I shall endevour to find another way around it.

Thanks a lot

Kind regards

James


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

Where exactly are you trying to use the formula??.... in conditional
formatting? or directly into a cell? If in conditional formatting then
you should know that conditional formatting can NOT change the contents
of a cell only the format.

I'm not an expert but as Bob said not too many things are imposible in
excel so all you need to do is give a little more details as to what
your trying to do.


Regards

Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=514574