+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting-Highlight entire column with today's date.

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Warsaw, KY
    MS-Off Ver
    Excel 2003
    Posts
    1

    Conditional Formatting-Highlight entire column with today's date.

    I have a list of data on a spreadsheet that I need some help using the conditional format...

    I would like to highlight the entire column that is in the same column as today's date. So if I open it 2 days from now then that day's column would be highlighted.

    Can someone please help?
    Attached Files Attached Files

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,844

    Re: Conditional Formatting-Highlight entire column with today's date.

    OK, to make this easier...

    In C2, enter 1/1/13, then fill that right to BK2.

    If you just want the actual day number to appear as in your example, then apply a Custom date format to those cells (C2:BK2): "d" without the quotes.

    Then, select cells C2:BK26, and click on Conditional Formatting, and use this formula:
    =C$2=TODAY()

    Select the color you want today's column to be highlighted, and click OK.

    - Moo
    Last edited by Moo the Dog; 01-24-2013 at 05:04 PM.

+ 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