Results 1 to 2 of 2

Conditional formatting

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-14-2012
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    143

    Conditional formatting

    I need to use conditional formatting to format the cells in B column to alert me when the information in column b is 12 hours or less using the time and date of the computer.
    Example:
    B5, B6, B7 would be "Red" and B4, B3, B2, B1 would stay the same color. Any help?
    Not sure how to do this.
    I have uploaded a file to use.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  2. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 PM
  3. Replies: 3
    Last Post: 05-15-2012, 04:13 PM
  4. Replies: 1
    Last Post: 03-05-2012, 06:20 PM
  5. Replies: 2
    Last Post: 11-02-2007, 12:03 PM

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