Creating a dropdown list ... Excel and Google Sheets. If you use Microsoft Excel as your preferred analytic tool, you might already be familiar with the concept called conditional formatting.

You could also choose the variable value from a drop-down list you create in Excel. So far, I've talked about how conditional formatting can help you to identify certain values within a set of data.

An curved arrow pointing right. Conditional formatting in excel allows you to format cells based on a set of rules. This will draw attention to the data you want to highlight and make your ...

You can now see a drop-down ... task list more dynamic, you can use formatting where the system formats your cell based on specific values and text. In the example below, I will show conditional ...

Note: We have included screenshots of Excel ... follow the same steps. The list of file extensions will be different as per the app. Here you can find a drop-down list called Save files in ...

An curved arrow pointing right. Conditional formatting in Excel allows you to format cells based on a set of rules. This will draw attention to the data you want to highlight and make your ...