A multi-metal colorimetric and fluorescent sensor based on Schiff base bearing an “O-N-N”-coordination site was developed. This newly designed sensor is a highly sensitive and selective “turn-on” fluorescent chemosensor towards Zn2+ which is less affected by physiologically relevant metal ions, especially Cd2+. The cell imaging experiment further confirmed that the sensor could be used for monitoring trace Zn2+ in living cells. On the other hand, evident color changes can be observed from colorless to yellow, orange and purple upon the sensor selective binding with Cu2+, Zn2+ and Ni2+, respectively. The corresponding color changes can be directly discriminated by “naked eye”. Significant response from spectral shift provided distinctly different profiles for each of the three metal ions. Overall, the sensor could simultaneously detect and differentiate three transition metal ions through fluorogenic (Zn2+) and chromogenic (Cu2+, Zn2+ and Ni2+) methods in real time and the detection limit was as low as 10−8 M in aqueous medium.