Excel Conditional Formatting based on date
Dear Experts -
I am looking for a way to write a conditional formatting formula that can easily be applied to any cell in my "Outstanding Debt" tab that will look at the Date/Year column and compare that date to the date that will be entered into cell "A2" the “outstanding debt as of “ date. The conditional format result would be any date that occurs before the date entered the worksheet would apply a strike through. For example if 1/1/2014 is inserted in "A2" for the as of date then any date that occurs before that date would apply a strike through to the amounts on that date line to the right. I can put in each cell say if A2>A7 apply formatting but I would have to change the formula for each row meaning the next line would read if A2>A8 and so on. I am hoping there is a better way to attack this. I have attached a file to show the structure of my worksheet. Thanks!
Sample-Data.xlsm
I am looking for a way to write a conditional formatting formula that can easily be applied to any cell in my "Outstanding Debt" tab that will look at the Date/Year column and compare that date to the date that will be entered into cell "A2" the “outstanding debt as of “ date. The conditional format result would be any date that occurs before the date entered the worksheet would apply a strike through. For example if 1/1/2014 is inserted in "A2" for the as of date then any date that occurs before that date would apply a strike through to the amounts on that date line to the right. I can put in each cell say if A2>A7 apply formatting but I would have to change the formula for each row meaning the next line would read if A2>A8 and so on. I am hoping there is a better way to attack this. I have attached a file to show the structure of my worksheet. Thanks!
Sample-Data.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER