Hello! I'm working on a spreadsheet with phone numbers for employees
and departments. I've been asked to have the department info list in
bold.

For example, say I've got entries for:
Accounting
Allen
Carla
Controller

It's easy to use conditional formatting to find and bold one department
at a time: Cell value equal to ="Accounting" (I attached a Word file
with a screenshot, for your reference.)

How would I adjust the formula to include additional items? We have
20+ departments!

Since this file may be widely distributed, and I'm not sure what
security settings the users will have, I'm trying to refrain from using
macros.

All help and suggesstions are sincerely appreciated!


+-------------------------------------------------------------------+
|Filename: Excel Screen.doc |
|Download: http://www.excelforum.com/attachment.php?postid=5139 |
+-------------------------------------------------------------------+

--
String
------------------------------------------------------------------------
String's Profile: http://www.excelforum.com/member.php...o&userid=37042
View this thread: http://www.excelforum.com/showthread...hreadid=567697