Results 1 to 14 of 14

Conditional Formatting based on between dates and a word in another cell

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2018
    Location
    Reno, NV
    MS-Off Ver
    2016
    Posts
    6

    Conditional Formatting based on between dates and a word in another cell

    Interlocal and Services.JPG

    What I want to do is have Conditional Formatting look to see if the Ending(B2) date is 90 days from now and if the Type(C2) is Interlocal, if so highlight the cell. I want Conditional Formatting to look to see if the Ending(B2) date is 180 days from and if the Type(C2) is Services, highlight the cell. Then I want it to shut off after Today has passed.

    I can change the highlighting of the date on and off based on if it is 90 days from now and if today has past, but then that doesn't give me if it is Interlocal or Services. I used Conditional Formatting Cell Value between =TODAY()+90 AND =TODAY() to turn on the start of the 90 days and turn off after today has passed. It worked in the date field, but nothing is working if I have it in the Type field and use other formulas.

    Past this I am lost.

    Any help would be great, I am new to this posting.
    Thank you
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting based on either a word, a letter or a number
    By Cidona in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 12-11-2017, 11:11 AM
  2. [SOLVED] Conditional Formatting based on given dates
    By fizzwolf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2017, 12:20 PM
  3. Replies: 8
    Last Post: 05-01-2015, 02:07 PM
  4. [SOLVED] Conditional formatting based on a word in a cell
    By dprobst in forum Excel General
    Replies: 2
    Last Post: 08-22-2014, 08:05 AM
  5. Replies: 8
    Last Post: 05-07-2014, 04:57 AM
  6. Need help with Conditional Formatting based on DATES
    By celeliza in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-23-2012, 09:53 AM
  7. Replies: 1
    Last Post: 08-17-2012, 08:16 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