Formula Problem

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

Not sure what 'that cell' is but maybe

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"superkopite" <superkopite.23jw2m_1140477002.9577@excelforum-nospam.com>
wrote in message
news:superkopite.23jw2m_1140477002.9577@excelforum-nospam.com...
>
> 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,BC3>1),BC3,0)

HTH
Jean-Guy

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

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" <superkopite.23jz2y_1140480900.7208@excelforum-nospam.com>
wrote in message
news:superkopite.23jz2y_1140480900.7208@excelforum-nospam.com...
>
> 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