Excel’s conditional formatting can help you keep track of
positive or negative changes in your business. For example, suppose you’ve
entered total first quarter sales for each of your stores in J2:J24, and
entered total second quarter sales in range K2:K24. You would like to know
which of your stores’ second quarter sales increased over the first quarter. To
find out this information, follow these steps:
- Go to
Format: Conditional Formatting.
the drop-down arrow and select Formula Is.
the following formula:
the Format button.
the Pattern tab, select light gray.
All cells for each store that attained higher sales for the
second quarter will be shaded in gray.
Note: When you
enter the formula in step 4, ensure that the column references are absolute.
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays