|
In this
example, I've used the TODAY() function to determine how many days late
each invoice is, and then I used Conditional Formatting to change the color
based on that. We have a FREE video
tutorial that shows you how to do this step-by-step.
I also cover Conditional Formatting in much more detail
in my Excel 104
class. Want to learn how to extend Conditional
Formatting to include more than 3 options with a little bit of VBA code?
Click here. |
