+ Reply to Thread
Results 1 to 3 of 3

Change a columns fill or border color based on current date

  1. #1
    Registered User
    Join Date
    10-01-2006
    Posts
    14

    Change a columns fill or border color based on current date

    I have a simple spreadsheet. A column for a persons name and 31 columns, one for each day of the month. I want to apply conditional formatting, either fill color or border color, to the date column of the current date when the spreadsheet is opened. Thanx

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Change a columns fill or border color based on current date

    Apply a conditional formatting rule like:

    =day(today())=B$1

    Where B$1 is your header containing the day number.

    See attachment for example
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-01-2006
    Posts
    14

    Re: Change a columns fill or border color based on current date

    that's what I'm looking for. was missing the =B$1 part. Thank you.

+ 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] change fill color of a range of cells based on color of a cell?
    By DarMelNel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2014, 04:48 PM
  2. Change color in text according the current date.
    By iffy100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-04-2013, 06:25 AM
  3. Change Cell Fill Color Based on Colors in 2 Columns
    By djkante in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2010, 08:07 PM
  4. Change a cell's formatting, like 25% gray fill or L,R,T,B border color ???
    By BaLLZaCH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2009, 05:19 PM
  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

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