Results 1 to 5 of 5

Conditional formatting - multi-item text list

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2006
    Posts
    3

    Conditional formatting - multi-item text list

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1