How do I create a custom format in Excel?

Answer 1

It depends on exactly what you're trying to do, but in general there is a Conditional Formatting option that can be used on a column/columns to do something like color each value <0 in red (and all other values green) in a financial report.

In this example the conditional formatting would be based on that inequality.

To teach this, I would ask you to share your screen with me so I can guide you through doing the specifics on your own during a lesson tailored to you, so you learn best.

Please contact me with any questions or to schedule a lesson.

Thanks!