do you know if there is a way i can replce the "6" below with a cell
reference?

for example: =if(countif(a1:a100,"X64"),"Warning","")

How about this:
=if(MAX(a1:a100)X64,"Warning","")