Results 1 to 2 of 2

Conditional Format on date driving me mad

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-09-2007
    Location
    UK
    MS-Off Ver
    2019 & 365
    Posts
    304

    Conditional Format on date driving me mad

    Hi Guys,

    I need a conditional format formula that looks at the date and says if less that 14 days old cell colour green, if 15 to 25 days old sell colour red, if 26 days old or older cell colour red.

    The range of cells it needs to apply to is B5:B325 in the attached sheet.

    I have tried lots of different formulas but none work, plus its late on a Friday afternoon here, its hot and sunny and I am stuck inside doing reports on the last day of the month when I should be out on my jet ski......

    Thanks BVG
    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