Results 1 to 8 of 8

How to make Conditional Formatting Ignore '+' & '-' values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-04-2016
    Location
    Newcastle
    MS-Off Ver
    2016
    Posts
    107

    Post How to make Conditional Formatting Ignore '+' & '-' values

    Hi,

    I'm attempting to use conditional formatting to compare values, however i want '+' and '-' to be ignored.

    For example if two cells were the same my sheet will highlight the one of the cells yellow. However if one cell contained '3' & the other contained '3+/3-' conditional formatting recognizes
    '3+/3-' as a greater value than '3' so this rule would not be applied.

    So i want my conditional formatting rule to ignore + and - symbols next to numbers.

    I've attached an example sheet.

    Thanks,
    Liam
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to get conditional formatting to ignore #DIV/0 cells
    By juntjoo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2016, 09:49 PM
  2. [SOLVED] How to modify conditional formatting to ignore specific values
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2015, 07:44 AM
  3. [SOLVED] Make conditional format ignore blank cells.
    By Graham Pall in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-22-2015, 09:15 AM
  4. [SOLVED] Ignore first row when using conditional formatting formula?
    By kilbey252 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-17-2015, 07:40 AM
  5. Ignore Duplicate Values In Conditional Formatting
    By mightyeskimo in forum Excel General
    Replies: 13
    Last Post: 09-18-2010, 01:28 PM
  6. how to make a graph ignore values I do not fill in?
    By Garashta in forum Excel General
    Replies: 1
    Last Post: 05-17-2010, 11:42 PM
  7. Make Chart ignore zero values
    By jevery in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-02-2009, 06:55 AM

Tags for this Thread

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