Formula Problem

[superkopite]

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 i
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

Jame

 

[Bob Phillips]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[pinmaster]

Maybe:

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

HTH
Jean-Guy

 

[superkopite]

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

 

[Bob Phillips]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[pinmaster]

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