Forum Discussion
Custom Excel Date Formulas and Conditional Formatting
Help! I really hope you can respond to this and help me! I need a formula(s) to apply conditional formatting based on various dates in a column both on the same tab and from a previous tab in the...
Please attach a sample file with few of your sample data then show your desired output manually so that we can make it by formula.
Harun24HR I'm sorry it has taken so long to reply, work has been very busy. I attached a Word Document that should help. Thank you!
- Icon sets only works on value, not over formula. So, if you want icon set conditional formatting then use a helper column (an extra column where put formula) set icon based on value of that helper column.