I have used the following formula and it worked very well.

=AND(CELL("format",A1)=CELL("format",B1),CELL("for mat",A1)=CELL("format",C1))

My next question is as follows:
I want to add another column with a dropdown of the different units of measurement, eg %, dates, numbers, etc.

How can I use this formula to detect different formats in all the columns?