Results 1 to 14 of 14

Conditional formatting to highlight multiple values with single rule?

Threaded View

  1. #1
    Registered User
    Join Date
    05-25-2015
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    4

    Question Conditional formatting to highlight multiple values with single rule?

    I have a large spreadsheet and use conditional formatting to highlight the cell background of particular values (which are numbers). I have approximately 20 values that I need highlighted.

    At the moment, I have a separate conditional formatting rule set up for each value I am interested in. However, it would be preferable if I could have a single conditional formatting rule/formula to do this, as the values I am interested in change from time to time and it would be faster to update a single formula.

    Is it possible to do this?

    For example, in my spreadsheet, I want to highlight any cell that has values 3, 42, 65, 87 etc.

    Thanks in advance!
    Last edited by chapzboy; 05-27-2015 at 11:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-25-2014, 05:17 AM
  2. [SOLVED] A conditional formatting rule that will highlight a cell based on certain criteria/date
    By FEL2014 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2014, 03:51 PM
  3. Replies: 5
    Last Post: 07-03-2013, 12:51 AM
  4. [SOLVED] Fx to highlight multiple values from a list using conditional Formatting
    By HooligaD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-08-2013, 03:03 PM
  5. Conditional Formatting of Multiple Values in a Single Cell
    By mliang87 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2013, 06:44 PM

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