If a cell contains a string, say "NCT" or "nct", conditional format shall work. The string may be with a date entered i.e. "05/05/2006 NCT"
Same said cell is currently set to only allow dates.
How can i achieve that
Can data validation be set to only allow a date, and/or "date NCT" as above?