Hi Everyone
Need a little help please with conditional formatting. Example file attached that shows where I have got up to so far.
Example 1 - conditional formats specific calendar dates Green for completed and Red for incomplete days
Example 2 - conditional format specific dates for specific number of days
Example 3 - conditional format specific row according to colour choice from data validation drop down colour choice.
Example 4 - This is where I need help I would like to conditionally format from start date to end date or start date for actual number of days but be able to choose what colour the row is as in example 3.
Any help much appreciated
Bookmarks