Results 1 to 5 of 5

Help with conditional formatting formula

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Help with conditional formatting formula

    Hi,
    I'm sure this will be easy for someone, but it has me going bold!

    I'm trying to format a cell based on a calculation of days from today + a date in a cell, plus the text in another cell. There's an "or" in that the cell needs to be highlighted based on;

    The text cell not stating "Rarely" and the date being over 360 days old

    OR

    The text cell being equal to "Rarely" and the date being over 720 days old

    I've tried:

    =IF((E4-TODAY())<-360,B4<>"Rarely")=OR((E4-TODAY())<-720,B4="Rarely")

    And

    =IF(E4-TODAY()<-360,B4<>"Rarely",IF(E4-TODAY()<-720,B4="Rarely"))

    But they don't work completely. Any help much appreciated.

    Thanks!
    Last edited by Marlowe Nots; 03-05-2010 at 09:28 AM.

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