أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
I think the best way is to use Conditional Formatting.
You can use may conditions that check the cell content and apply formatting accordingly.
Cheers
