Results 1 to 6 of 6

conditional formatting--any years, all years, and an at least

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    conditional formatting--any years, all years, and an at least

    Hello. How would I create conditional formatting for the following? (spreadhsheet attached)

    Criteria 1, customer filed 2 or more claims in ALL years

    Criteria 2, customer filed 5 or more claims in ANY years

    Criteria 3, customer has 3 or more years of data, and they have at least 1 claim in every year
    Attached Files Attached Files

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 - Expiration Dates (2 Years)
    By viper6 in forum Excel General
    Replies: 6
    Last Post: 03-26-2020, 11:27 PM
  2. Conditional formatting based on number of years from now
    By jhiltabidel in forum Excel General
    Replies: 2
    Last Post: 12-17-2013, 09:27 AM
  3. [SOLVED] Conditional formatting with in between years, such as between 5-10 years old
    By gr8fawx in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-22-2013, 06:39 PM
  4. [SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-17-2013, 04:20 PM
  5. conditional formatting with years
    By prologueden in forum Excel General
    Replies: 2
    Last Post: 05-28-2012, 05:54 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