conditional formatting
hi all happy holidays, i need some help again , column h contains dates only (23/4/07)and i want to be able to fill cells with colors on certain conditions, for example all cells that hold the date 12/3/07 to be the color i require. i am using excel 2007 and the conditional formatting options only allow me to format cells containing today, tomorrow , last week etc but not for example any/5/2004 , i dont need to format the specific days just the months and years will do. any ideas please
If you want each year/month to have different formatting, then set them each up as a separate condition using 'formula is' and this formula:
=AND(MONTH(H1)=2,YEAR(H1)=2003)
If several dates you're looking to format will have the same formatting applied, you could use:
=OR(AND(MONTH(H1)=2,YEAR(H1)=2003),AND(MONTH(H1)=5,YEAR(H1)=2007))
To which you could add more AND( ) sections separated by commas.
Note: You can select the entire column and put this in, and it will automatically update for all rows going downward. Adjust your month and year values as necessary.
Last edited by Paul; 04-07-2007 at 10:15 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
sexgod 
Register To Reply
Bookmarks