Hi,

you must use conditional Formating.
Are you familiar with conditional formating ?? .