+ Reply to Thread
Results 1 to 3 of 3

conditional formatting

  1. #1
    Registered User
    Join Date
    03-03-2018
    Location
    West Coast
    MS-Off Ver
    2013
    Posts
    8

    Exclamation conditional formatting

    Hello,

    Need a pointer on an excel issue.

    i have a column where I input a value into and if it goes above a certain number, i need it to be highlighted a color.

    The cell is highlighted if the number is above, for example 1400......

    the catch is that we also add the date into this cell after the number, like this------------------1400(7/2/2018) and i just need it to look at the 1400 number and nothing else.

    I can set this up in conditional formatting and it works but not with the date and losing the date is not something I can do.

    thanks,
    Z

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: conditional formatting

    maybe a conditional format formula like this
    (for cell A1 for starters)

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: conditional formatting

    Hi,

    A few ways:

    Hardcoded for 1400 and Always 4 digits:

    =LEFT(I1,4)+0>1400

    Cell referenced and Always 4 digits:

    =LEFT(I1,4)+0>G1

    Hardcoded requirement, variable length:

    =LEFT(I2,FIND("(",I2)-1)+0>1400

    Cell referenced, variable length, Most Versatile and Recommended:

    =LEFT(I2,FIND("(",I2)-1)+0>G2

    See attached sample.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  2. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 PM

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