+ Reply to Thread
Results 1 to 3 of 3

Change color on just one date?

  1. #1
    Registered User
    Join Date
    08-09-2014
    Location
    Sweden
    MS-Off Ver
    M$ Office 2007
    Posts
    2

    Unhappy Change color on just one date?

    Hello!

    I have a question, I'm not exactly an expert user of Excel in Office 2007, (n00b) but I'm learning.

    However, I for statistics about how my Bitcoin Device's works and decrypts Bitcoins per day for trends and statistics, and so on

    Now while I was away so had the power gone, and for almost 24 hours so stood all still, I would now like to outline in red the date / dates where I have zero or very low running time for specific date, but I can only change Fragen for all dates, not individual dates.

    Anyone know if it is possible to do as I want? the stack's not exist in the data value is equal to zero (null) where by I want to be able to get the date in red color, and possibly also in bold. see print screen below.

    Thanks so much for your help in advance
    Best Regards
    Niclas a.k.a WDac from Sweden.

    URL -> \1
    Download to PC/MAX -> BTC_chart-Color-on_specific_date-2014-08-10_0444.png

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Change color on just one date?

    Hi and welcome to the forum

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff)

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-09-2014
    Location
    Sweden
    MS-Off Ver
    M$ Office 2007
    Posts
    2

    Re: Change color on just one date?

    Quote Originally Posted by FDibbins View Post
    Hi and welcome to the forum

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff)

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    Hi!

    Here´s the file, the 3 first tabs below are for this year, the others i just prepared for next year (2015)

    follow the red colored Column with date 2014-08-06 in the second tab.

    Attached filename "BTC-Mining-Stats.xlsx"


    EDIT-01: Thanks alot for the help, iam a bit shamed about my n00b exl workbook tho, i hope there is a solution tho this "problem" i have, or the "lack of feature"
    Attached Files Attached Files
    Last edited by wdac; 08-11-2014 at 03:23 PM.

+ 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. Change cell color according to date
    By hmvl44 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-09-2013, 07:40 AM
  2. Macro to Change color of cell after cross referencing date with a given date.
    By liajet24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2013, 12:33 PM
  3. Date color change if date exceeds 14 days
    By ayankinoz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-26-2010, 11:45 PM
  4. Replies: 5
    Last Post: 05-17-2006, 03:00 AM
  5. I want any date 90 days or older from current date change color
    By Big Abalone in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-23-2006, 12:10 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