conditional formatting?

  • Thread starter Thread starter joe
  • Start date Start date
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
 
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
 
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)
 
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...
 
thanks heaps guys. i used the following formula in the conditional formating
=COUNTIF($B$1:$C$5,A1)

again thanks

regards
joe
 
Back
Top