conditional formatting?

J

joe

hi guys,
i have a spreedsheet that i am using for setting up schedules. i
don't want to book someone in a certain workgroup when they are booked in
for another at the same time.
basically i want to format (?) a cell so that its value (name) does not
equal any value (name) in a table (just a group of 10 cells, 2x5, in the
same sheet).
what does work is using conditional formatting and stating that if the
cell equals another cell reference then it comes up red - thus indicating to
me that they are booked in twice. this is fine but i want to have 10
conditions like this (10 cells in the table) but i am only allowed 3
statements.

any ideas around this?

regards
joe
 
F

Frank Kabel

Hi Joe
if your cell is A1 and your range is B1:C5 try the following formula in
conditional format:
=COUNTIF($B$1:$C$5,A1)=0

Frank
 
B

Bob Phillips

Just a suggestion from reading the OP, this might be what you want

=COUNTIF(A$1:A$10,A1)>1

and pattern format to highlight these duplicates

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Bob
think you're right - messes it up :)
Frank

Bob said:
Just a suggestion from reading the OP, this might be what you want

=COUNTIF(A$1:A$10,A1)>1

and pattern format to highlight these duplicates
Click to expand...
 
J

joe

thanks heaps guys. i used the following formula in the conditional formating
=COUNTIF($B$1:$C$5,A1)

again thanks

regards
joe
 
Top