10/1/2008 1:45:30 AM
Excel Tip: Conditional Formatting
By Richard Rost
Lots of people ask me how you can take a list of invoices and VISUALLY display which ones are more than 30, 60, 90 days late... like make 90 day-old invoices BOLD RED.
You can do this with CONDITIONAL FORMATTING, which I teach in Excel 104, but I didn't cover this specific example. So, here it is:
Conditional Formatting - Tips & Tricks
Enjoy... and be sure to post your comments here or in the forum!
Keywords: excel tips conditional formatting today date