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

Chapter 18. Using Excel's Data-Managemen... > Using Formulas with Conditional Form...

Using Formulas with Conditional Formatting to Create Timelines

You can create seamless timelines that appear to have no formula in the cells with conditional formats. If you have to maintain schedules in business development, strategic planning, marketing, or production environments of any kind, this is one visual technique you can use. In Figure 18.7, the blocked timelines are really floating bars that reference the dateline across the top and the start and stop dates down the left.

Figure 18.7. Create floating timelines with conditional formats to manage time events.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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