CF : Check If Data as Real Date

[muhammad susanto]

hi all..

how to make conditional formatting with shading Red color for data is NOT a real date
my format date dd/mm/yyyy or dd-mmmm-yyyy
if blank data not highlighted red color too
for this :

Book1
	G	H
1	date	Explanation
2	31/12/2020	true format date
3	23/03/1989	true format date
4	12/12/2001	contains mark (') approstrop
5	24/13/2002	wrong format date
6	blank/empty cell
7	text	wrong format date
8	01/01/2005	true format date
Sheet1

any help, thanks in advance
.sst

 

[MARK858]

Wrong, being edited

 

[MARK858]

Or going by your original post

Book1
	G	H
1	date	Explanation
2	31/12/2020	true format date
3	23/03/1989	true format date
4	12/12/2001	contains mark (') approstrop
5	24/13/2002	wrong format date
6
7	text	wrong format date
8	01/01/2005	true format date
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:G8	Expression	=AND(OR(NOT(LEFT(CELL("format",G2),1)="D"),ISTEXT(G2)),G2<>"")	text	NO

 

[muhammad susanto]

hello mark858, perfecto!!! thank you very much!!

​

 

[MARK858]

You are welcome