Results 1 to 6 of 6

Conditional Formatting of Cells

Threaded View

  1. #1
    Registered User
    Join Date
    07-19-2015
    Location
    Tampa Florida
    MS-Off Ver
    xp
    Posts
    8

    Conditional Formatting of Cells

    Using attached, if cells in column U = blank, then highlight cells in column R in Light Red whose dates are date entered plus 60 to 89 days from current calendar day (today) and change color to dark red when days hit day 90 and stay dark red until cells in column U are no longer blank and have a date entered into them.

    Thanks
    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. Conditional Formatting - Color Formatting for Blank Cells
    By mlbdc2012 in forum Excel General
    Replies: 10
    Last Post: 02-10-2015, 06:28 AM
  2. Replies: 2
    Last Post: 12-05-2014, 07:15 AM
  3. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  4. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  5. Replies: 2
    Last Post: 09-19-2013, 10:34 AM
  6. Replies: 3
    Last Post: 05-15-2012, 04:13 PM
  7. Replies: 4
    Last Post: 01-06-2012, 05:07 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