 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Conditional Formatting for a certain month
Having a bit of an issue at the moment, ive got the Cell for instance A1 Which contains 04-Jan-06 Basically Im after some conditional formatting to say if the month is January, then make the cell blue. Which will then lead to me making the other cells different colours depending on their month, but again, it has to be in this format (DD-MM-YY) Thanks for any help, muchly apreciated Assuming a properly formatted date, formula is =if(month(a1)=1)  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Having a bit of an issue at the moment, ive got the Cell for instance > A1 [quoted text clipped - 10 lines] > > Thanks for any help, muchly apreciated Hey, thanks for the help, i tried that though and it says the formula contains an error. This is the exact copy and paste of the date im testing with: 04-Jan-06 so tried: =if(month(I17)=1) and =if(month(I17)=JAN) and =if(month(I17)='JAN') anymore ideas please? > Assuming a properly formatted date, formula is > =if(month(a1)=1) [quoted text clipped - 17 lines] > > > > Thanks for any help, muchly apreciated try it this way in cell i17 assuming a properly formatted date in i17 =IF(MONTH(i17)=1,1,0) SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Hey, thanks for the help, i tried that though and it says the formula > contains an error. [quoted text clipped - 34 lines] >> > >> > Thanks for any help, muchly apreciated Apologies but still having issues, used: =IF(MONTH(I17)=1,1,0) in conditional formatting and the dates currently in my column are: 04-Aug-06 02-Jan-05 01-Feb-02 04-Jan-06 and the conditional format highlighted them all :s > try it this way in cell i17 assuming a properly formatted date in i17 > =IF(MONTH(i17)=1,1,0) [quoted text clipped - 41 lines] > >> > > >> > Thanks for any help, muchly apreciated In CF, change Condition 1 to Formula Is, and just use the formula =MONTH(I17)=1 assuming the dates start in I17 SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > Apologies but still having issues, used: > [quoted text clipped - 53 lines] > > >> > > > >> > Thanks for any help, muchly apreciated Hey, i tried that, it hightlights the month of Jan, but also other months too :s > In CF, change Condition 1 to Formula Is, and just use the formula > [quoted text clipped - 68 lines] > > > >> > > > > >> > Thanks for any help, muchly apreciated Note that all the formulae are looking at I17, whereas in your first post you referred to A1 - are you sure you are referencing the correct cell? Sometimes Excel puts quotes around the formula - go back in and delete these if necessary. Try to get the correct effect on just one cell, then you can use the Format Painter to apply it to other cells. Hope this helps. Pete > Hey, i tried that, it hightlights the month of Jan, but also other > months too :s [quoted text clipped - 71 lines] > > > > >> > > > > > >> > Thanks for any help, muchly apreciated Maybe blanks? Try =AND(I17<>"",MONTH(I17)=1) SignatureHTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) > Hey, i tried that, it hightlights the month of Jan, but also other > months too :s [quoted text clipped - 71 lines] > > > > >> > > > > > >> > Thanks for any help, muchly apreciated
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.