Conditional formaytting between worksheets

T

Troy

can anyone help i am currently working on a daily deployment sheet i
which i am trying to make sure that all the associates i am placing i
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 cel
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 t
me.
Am i approaching this the wrong way as this does not seem to b
possible. I think i may have rethink how i go about creating m
deployment sheet. Cheers for any help or hints that come my way
 
H

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.
 
Top