Hi There,
In reference to the attached example file I would like to have cell E5 turn green when "Done" is selected from the drop down in cell F5 but I would like the other conditional formatting to also remain in place regarding the dates and only disappear when "Done" is selected.
Can you help?
Example File.xlsx
Bookmarks