I have a spreadsheet where I am trying to do conditional formatting based upon more than 1 criteria. I have tried several formulas, but am having no luck. There will be several separate conditional formatting statements and I'm aware of the hierarchy for processing. I'm trying to format cells between certain dates formatted in my "timeline cells" which contain monthly dates. 1 color for Type "Maintenance" and another for Type "Enhancement." The other criteria is only wanting to format the cells that fall between a "Start" date and a "Finish" date. I have all dates using the same format but each in it's own column. I'd attach a sample but I'm new here and not quite sure how.
Bookmarks