Conditional formaytting between worksheets

[Troy]

can anyone help i am currently working on a daily deployment sheet in which i am trying to make sure that all the associates i am placing in certain area's are not being deployed to the same area every day.
I was hopeing all i had to do was put a Conditional Format into a cell and if the same person appeared within a certain range of my worksheet, this would be picked up on the previous worksheet and highlight this to me.
Am i approaching this the wrong way as this does not seem to be possible. I think i may have rethink how i go about creating my deployment sheet. Cheers for any help or hints that come my way:

[HS Hartkamp]

From what I understand of your question, you are approaching this in the
right way.

Use conditional formatting
Formula = if(countif("A1:A100",A1)>1,TRUE,FALSE)
with condition is true some form of highlight.

To make sure you do not make typing errors in the names, you can use "data
validation" based on a list of values elsewhere.

If I'm wrong, then please rephrase the question.

Bas Hartkamp.


"Troy" <Troy.22tj8a_1139247300.79@excelforum-nospam.com> schreef in bericht
news:Troy.22tj8a_1139247300.79@excelforum-nospam.com...
>
> can anyone help i am currently working on a daily deployment sheet in
> which i am trying to make sure that all the associates i am placing in
> certain area's are not being deployed to the same area every day.
> I was hopeing all i had to do was put a Conditional Format into a cell
> and if the same person appeared within a certain range of my worksheet,
> this would be picked up on the previous worksheet and highlight this to
> me.
> Am i approaching this the wrong way as this does not seem to be
> possible. I think i may have rethink how i go about creating my
> deployment sheet. Cheers for any help or hints that come my way:
>
>
> --
> Troy
> ------------------------------------------------------------------------
> Troy's Profile:
> http://www.excelforum.com/member.php...o&userid=31228
> View this thread: http://www.excelforum.com/showthread...hreadid=508985
>