|
|
Access ¨
Excel
¨ FrontPage ¨ Outlook ¨
PowerPoint
¨
Word
¨ Miscellaneous ¨
Tutorials
¨
Windows
¨
Free Downloads
|
|
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
