If a field A2 has a year 18 or older, I want row A3 : A10 become coloured.
How to do that with conditionals or with another way?
If a field A2 has a year 18 or older, I want row A3 : A10 become coloured.
How to do that with conditionals or with another way?
What exactly do you have in those cells - just 18 or is it a date, or something else?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The column A1 and down are years.
1978
1957
2005
etc
etc
A2 - A10 are infos of different kinds, can numbers, text etc
From the looks of it, those are not really years (as in dates), they are just values, but thats OK we can work with that.
So you want this based off todays date?
assuming your data is something like this...
A B C D 1Year aa bb cc 2 1978 10 20 30 3 1957 110 120 130 4 2005 210 220 230
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$A2 < YEAR(TODAY())-18 format fill your color
Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks