conditional ref a cell on a diff worksheet 2

[renartbrazil]

=LEFT(C4,LEN($C$2))=$C$2

I use this and many other variations but now taking it a step further and do not know how to make it reference cell C2 on a worksheet called parameters. I have tried but can not get it.

 

[dhulbert]

renhart

=LEFT(C4,LEN(parameters!$C$2)} would do it.

All you need to to to work it out is put = in the cell your formulae is going in then click the cell on the other sheet and you can see the syntax for yourself.

 

[SkipVought]

Hi,

It's really quite simple.

Enter this much
[tt]
=LEFT(C4,LEN(
[/tt]
at this point, select the sheet tab and then the cell.

Finish with 2 END-PARENTHESIS.


HOWEVER,

this won't work in Conditional Formatting (referening cells on a different sheet) unless the reference on the other sheet is a Named Range.


Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[renartbrazil]

i see how the ranges work, never used them before but made sense skip. may have to look at dhulbert's again, think i had little trouble with that, may have been missing somethign unless the named range is need for sure. leaned something new, thanks for the advise

 

[KenWright]

LOL - What do you mean 'IF' it's needed for sure? Skip just said so didn't he.

You CANNOT reference another sheet with conditional formatting, but you CAN reference a named range. If the named range refers to another sheet then bingo, there's your workaround. dhulberts formula will NOT be accepted within the CF formula box and you will simply get a message reiterating what I have just said. It would be a more helpful message if gave you the workaround that Skip has told you, but hey, you can't have everything - That's what these forums are for

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[renartbrazil]

hey i know, just giving benefit of the doubt, i was glad to find the out how to go about this. effort is always good. i know i had a heck of a time trying it on my own, so now we both know that is not possible.