Put that list of 20 departments in A1:A20 of a different worksheet (say Sheet2)
(don't put anything below those departments)

Then select that column A of sheet2
Insert|Name|Define|MyDepts

Then back to your cell (say A1 of sheet1)
format|conditional formatting
formula is:
=COUNTIF(MyDepts,A1)0

Give it a nice bold format.


String wrote:

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

--

Dave Peterson