Results 1 to 6 of 6

Changing Color Font based on date/time column

Threaded View

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Changing Color Font based on date/time column

    Hi,
    I need some help with a macro and I’m not very proficient in visual basic

    What I want to do is change the font color each time the date/time row changes.

    Column A3 has date/ time is in that column

    I want to change the font color for Range A3:H3 to red

    Then in the next row (A4:H4) change it to red if the date / time in A4 is the same as A3, but if it is higher by 30 minutes change it to another color. This continues down another 30 rows (A?:H?) or so until no more data in Time / date column.

    I could not figure out how to do this in the conditional formatting manager so I turned to a simple macro that isn’t so simple for me.

    Thanks,

    Mike
    Last edited by greymoore; 12-19-2012 at 03:40 PM.

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