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.
Last edited by Ron Coderre; 01-11-2013 at 05:12 PM.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1