Profitwyse Advanced Excel & Access Tip Series #5

Excel Conditional Formatting For User Interfaces

In this Advance Excel Tip Video #5, I am going to show you how you can help your users better navigate your Excel workbook applications using Conditional Formatting.  Utilizing Excel Conditional Formatting for user interfaces reduces the need for custom Visual Basic solutions to this common problem.  One thing to note that many experience Excel users do not completely understand is that you can layer your conditional formatting over the same range of cells.  This technique takes advantage of this capability within Excel.

Please comment below and send us a message if you have questions or would like assistance with your Excel application.

Gaining a competitive edge, which can be as simple as following a formula, will require some infrastructure and tools.  At Profitwyse, we specialize in implementing these tools around profitability improvement initiatives.  If you are a business owner that is struggling to develop processes that deliver goals, contact us today.