+ Reply to Thread
Results 1 to 7 of 7

Different background color for entered values then values from formula

  1. #1
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Different background color for entered values then values from formula

    How to grey out when numbers are entered manually so they look different than values got by formula?

    If cell is colored manually (red square) it stay red.
    Attached Files Attached Files
    Last edited by zbor; 05-09-2012 at 09:51 AM.

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Different background color for entered values then values from formula

    Hi zbor,

    Please see attached if it suits your need.

    Regards,
    Bing.

    EDIT: Please look into named ranges and conditional formatting in Sheet2
    Attached Files Attached Files
    Last edited by quekbc; 10-21-2011 at 07:37 AM.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,093

    Re: Different background color for entered values then values from formula

    You can use a function to test if there is a formula and then Conditional Formatting

    See the example


    Please Login or Register  to view this content.

    Regards
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Different background color for entered values then values from formula

    Maybe:

    Please Login or Register  to view this content.

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Different background color for entered values then values from formula

    quekbc: works great. ty

    TMShucks: works too, but I think quekbc is faster

    Kyle123: Sorry, it turns number to transparetn too... Maybe I miss something...

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Different background color for entered values then values from formula

    hmm, I'll have a look.

  7. #7
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Different background color for entered values then values from formula

    No need for me since problem is solved

+ 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