Results 1 to 5 of 5

highlight entire row is first cell is 60 days older than today

Threaded View

  1. #1
    Registered User
    Join Date
    03-11-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question highlight entire row is first cell is 60 days older than today

    Hello,

    I cannot figure out how to use conditional formatting to highlight an entire row based on the contents of one of its columns. What happens is that we need to identify everyone that has been joined 45 days ago and 60 days ago. Ideally, their row would highlight yellow (at 45days) and red (at 60 days). Is there any way to do this? I have attached a simple file so you can see what i'm talking about. Thanks!
    Attached Files Attached Files

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