• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

2. Hacking Excel for Financial Analysis > Make Good and Bad Values Stand Out

Make Good and Bad Values Stand Out

In an Excel spreadsheet, you can highlight red flags and green-light results with formatting.

Studying investments generates a lot of numbers. You need the information, but you can also get lost in the forest as you scrutinize every tree. Excel charts [Hack #13] are good for emphasizing trends in sets of numbers, such as sales and earnings growth, or P/E ratio changes, but Excel can also highlight important values in numerical tables. Excel’s conditional formatting changes the colors in worksheet cells based on the value in a cell or the results of a formula. By associating good results with green and bad results with red, you can draw attention to desirable values and red flags, making the big picture visible at a glance.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint