|
|
Access ¨ Excel ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨ Word ¨ Miscellaneous ¨ Tutorials ¨ Windows
Free Downloads
¨
Suggest an Article
¨
Fix an Article
After you format your files in Excel, you can use a laser printer to see if the formatting is correct. HP toner cartridges are effective and inexpensive, and they can easily be used in the printer that is hooked up to your laptop computer.
Sometimes, you need to just see something for it to work. In the following, we highlight all 3 cells of a record if the invoice date is older than 6 days (now one week old). I couldn't get this right the first time, and Jake Hilderband pointed out that I only needed a $ in front of the column reference, and not in front of the row reference. Don't ask me how, but the conditional formatting works a lot like autofilling a formula. You enter just the first one (here it's cell B2) and it automatically works on all of them (B3 through B9). If we remove the $ then it would be looking for dates in columns A and C as well—not good.
This article was actually requested by "Fraryl" via our Article request form. So, I'll provide the example that he/she did.
Example: If cell B3 has the word unsatisfactory, italicize the content in cell A3. Note how we put our text in quotes, as is done with most formulas. Admittedly, when I first did this, I also selected cell C1, and the italics formatting occurred in C4 and C8. Then I realized, I'd be looking first one cell down, and THEN to the right, which of course wasn't right.
Example: Format as red font color the highest value in a range.
All contents copyright Anne Troy 2005-2006
