Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

Conditional Formatting

Custom Conditional Formatting Rules

By Jeff Lenning | July 11, 2013 |

Today, we will look at using conditional formatting with formulas, data validation, and comparison formulas.  Think you are up for it?  Let’s do this thing. Let’s say we have a worksheet that computes the payment of a loan.  We can use the PMT function to easily accomplish this task.  The PMT function requires three arguments…

Read More