+ Reply to Thread
Results 1 to 5 of 5

Trim the data & If cells are greater then change the value conditional

  1. #1
    Forum Contributor
    Join Date
    06-09-2014
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Trim the data & If cells are greater then change the value conditional

    Hi,
    There can be data anywhere in the sheet
    If column K is greater than 60 then make it 60
    & if column K has data with decimal then remove all the data from decimal
    Macro I will put in this file only & sheet name will be changed
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,663

    Re: Trim the data & If cells are greater then change the value conditional

    Something like below.

    First select the range that you want to apply the operation to... and run the code.
    Please Login or Register  to view this content.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    616

    Re: Trim the data & If cells are greater then change the value conditional

    or

    Please Login or Register  to view this content.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    8,261

    Re: Trim the data & If cells are greater then change the value conditional

    Or simply...
    Please Login or Register  to view this content.
    Or If formulas to values then...
    Please Login or Register  to view this content.
    Last edited by sintek; 05-22-2020 at 12:30 PM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere.....
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember......Mark Thread as Solved.
    Excel Forum Rocks!!!

  5. #5
    Forum Contributor
    Join Date
    06-09-2014
    MS-Off Ver
    Microst Office 365 Plus
    Posts
    143

    Re: Trim the data & If cells are greater then change the value conditional

    Thnx Vraag en antwoord,sintek ,CK76 for soving this problem

+ 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] If one cell is greater than another, change fill color of other cells. If not, no change
    By nighttrain20 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2018, 10:08 AM
  2. [SOLVED] conditional formatting gray out cells greater than a value
    By adamheon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2018, 09:43 AM
  3. [SOLVED] Conditional Formatting when difference between 2 cells is greater than 5%
    By ebburtis in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-02-2016, 11:24 AM
  4. Replies: 9
    Last Post: 02-16-2013, 10:11 PM
  5. Replies: 2
    Last Post: 06-21-2010, 08:40 PM
  6. Conditional Formatting Greater than surrounding Cells
    By tmiller in forum Excel General
    Replies: 1
    Last Post: 03-30-2007, 12:15 PM
  7. Conditional formatting for the greater of 7 cells
    By guest123 in forum Excel General
    Replies: 8
    Last Post: 01-15-2007, 01:39 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