Macros for validation in Excel

i want to write validation for each column Column1 to Column4 in VBA that it should be in this particular format only

And i have to check condition that if ColumnName6 = ColumnName7 && ColumnName5 = OK then ColumnName8 is NOC else CON