Register now or log in to join your professional community.
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
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.