Step 1: To apply conditional formatting first go into the View tab, and then within the same tab click View settings to open up the dialogue box.
Step 2: Once the dialogue box appears on the screen. Once there click Conditional Formatting. Then another dialogue box will appear. Click Add, and type the name of your new colleague. Click OK to apply your changes.