Final question in our data analyst interview questions and answers guide. A Data Analyst can use conditional formatting to highlight the cells having negative values in an Excel sheet. Here are the steps for conditional formatting:
- First, select the cells that have negative values.
- Now, go to the Home tab and choose the Conditional Formatting option.
- Then, go to the Highlight Cell Rules and select the Less Than option.
- In the final step, you must go to the dialog box of the Less Than option and enter “0” as the value.