+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting, multiple values

Hybrid View

  1. #1
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,758

    Re: Conditional formatting, multiple values

    One method is to go to Conditional Formatting, then Manage Rules. Use New Rule three times, once for each name you want to match. Because you want to format a cell other than the one with the value you are checking, you should use "Use a formula to determine which cells to format" and it will reference $A1. Then you can copy the formatting to other cells and the relative part of the reference will be copied correctly, just as when you copy formulas with relative references to other cells.
    Last edited by 6StringJazzer; 02-26-2010 at 03:58 PM.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

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