Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excel and conditional formatting
Name: aparmar Date: April 28, 2008 at 07:50:18 Pacific OS: xp CPU/Ram: 2gb Product: toshiba
Comment:
Dear All,
I have a small query on excel and conditional formatting. Here goes:
I have a column that has all dates in them displayed as 02.08.2008 or 15.09.2008.
My question is how do I format these cells so that if the date goes over lets say todays date it highlights the cell in a colour for example?
Summary: My example was for an assumed date in A1, so I only gave the instructions for that row. If you want to conditionally format more rows, select them and follow the steps above. The only change to the fo...
Summary: Well, that's a bit clearer! I don't have 2007, but the concept is the same as in 2003. You need to base your formatting on the results of an IF statement. If the result is True, the pattern chosen wil...
Summary: Have you searched the Excel help files for Conditional Formatting and looked at: "Locate duplicates by using conditional formatting." It's there in Excel 2003...can't speak to other versions. ...
0 
