Hi All, a newbie to this forum and an intermediate (bordering beginner) to Excel. I'm having problems with conditional formatting for future dates. Here's the set up:
I have two query tables on one Worksheet, both using Power Query. (link to pic below) Column E has two data sets (two tables on top of each other) for expiration dates. The date set titles are not exactly the same. I'm trying to use conditional format to highlight the expiration dates that are within 3 years of the current date. I was able to do it for a column with percentages. I have tried a couple of formulas but selecting a single column or a few cells is proving difficult. It seems to not like dates and want to do the whole table and then some. But when I was able to get a result, it was a highlight of only one cell, the bottom cell of each table. Any help is appreciated. Thanks.
http://tinypic.com/view.php?pic=1tsw7a&s=9#.XKPk5RJrxaQ
I have two query tables on one Worksheet, both using Power Query. (link to pic below) Column E has two data sets (two tables on top of each other) for expiration dates. The date set titles are not exactly the same. I'm trying to use conditional format to highlight the expiration dates that are within 3 years of the current date. I was able to do it for a column with percentages. I have tried a couple of formulas but selecting a single column or a few cells is proving difficult. It seems to not like dates and want to do the whole table and then some. But when I was able to get a result, it was a highlight of only one cell, the bottom cell of each table. Any help is appreciated. Thanks.
http://tinypic.com/view.php?pic=1tsw7a&s=9#.XKPk5RJrxaQ