+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Question

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Brighton
    MS-Off Ver
    Excel 2003
    Posts
    2

    Conditional Formatting Question

    Good Evening all,

    Im currently working on a database that contains vaccinations for individuals and when they expire.

    This is the problem I currently have... ROW 2 Meningitis C vaccination is required up to the age of 25 (I would like these cells red), ROW 3 for individuals over 25 it isn't (I would like these cells blank). ROW 3The only other thing is that some individuals under 25 have had the vaccination already and so there is a date of when they had it in the cell (I would like these cells green).

    I have attached my spreadsheet example.

    I would ideally like a formula to automatically do all 500 entries I have.

    Thanks for your help in advance.

    work practice.xlsx
    Last edited by Ron Coderre; 01-11-2013 at 05:12 PM.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Conditional Formatting Question

    Welcome to the forum

    This is a moderated forum so please click the Forum Rules link and take a few minutes to read the rules.
    You'll see that we insist on clear concise thread titles. Since you're new, I'll edit your title for you...this time.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ Reply to Thread

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