If I have a column with a date in format 16/01/2001, would it be possible to conditionally format the column after it to say
if the date is after 2001, then the results is Yes
If the date is between 1980 and 2001 then the results is maybe
If the date is pre 1980 the results is NO
Where the result is just text saying either, yes, no or maybe?
couldn't find any answers via google
Bookmarks