Every day, thousands of questions about Excel are posted on the internet.

Many go unanswered because they are unclear, or too complicated to understand.

Below are six tips to write a better question that will attract good answers quickly.

Sample screenshot - how to highlight overdue invoices

State your goal clearly and briefly

Be clear about what you want.

For example:

3.

Reduce and simply

Less is more.

Sample screenshot - how to highlight overdue invoices

Do not venture to explain your requirements at length in text.

Distill your problem to its essence.

Build a tiny example onone worksheet.

Sample screenshot - how to highlight overdue invoices

Be sure to include (1) sample data and (2) desired result.

For example:

5.

Show your formula

Include the exact formula you are trying to use.

Sample screenshot - how to highlight overdue invoices

It may not work correctly, but it helps others understand how you are approaching the problem.

Sample screenshot - how to highlight overdue invoices