+ Reply to Thread
Results 1 to 2 of 2

Eligible conditional formatting

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,667

    Eligible conditional formatting

    Hello,

    I Need to set a conditional formatting.
    Scenario:
    After I enter the filing date then the 270 and 360 date return will appear.
    Let say that I am working the calendar date of 2/28/22.
    Under the 270 date return 2/6/22, then this will be “ELIGIBLE” because before the calendar date.

    Then, under the 360 days is “NOT ELIGIBLE” because it is not after the date return 05/07/22.
    So it’s actually from the calendar date to set a conditional formatting. If the date return is before the calendar date then “ELIGIBLE” and the calendar before the date return then it’s “NOT ELIGIBLE”.

    Color blue “ELIGIBLE” and color red “NOT ELIGIBLE”.
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: Eligible conditional formatting

    i did post , and seems to have gone !!!

    anyway
    2 conditional format rules for each cell
    select the merged cells - not great using merged cells
    anyway

    =$K$14="Not eligible" - fill yellow , font red
    and 2nd rule
    =$K$14="eligible" - fill yellow , font blue

    same rules but for B14 instead of K14

    then in the cell use an if
    =IF(B12<M3,"ELIGIBLE","NOT ELIGIBLE")

    this is where merged cells start to cause issue with the cell reference

    Also what do you want for date is the same

    then instead of < just use < =
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Renaming and eligible charactrs
    By Kaizan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-12-2020, 06:40 AM
  2. Color change when driver becomes eligible for another trip
    By bob19taylor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2018, 09:46 AM
  3. Replies: 2
    Last Post: 10-04-2017, 01:14 PM
  4. Replies: 2
    Last Post: 06-27-2016, 11:47 AM
  5. totaling a persons eligible amount
    By TheVolkinator in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2016, 06:56 PM
  6. Formula for Vacation Days when eligible
    By tastjuste in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2013, 08:11 PM
  7. eligible if
    By gricardo in forum Excel General
    Replies: 6
    Last Post: 02-27-2009, 05:57 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