 |
 | 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 / August 2007Conditional formatting: If text or If date?
I have a spreadsheet that tracks reports. In a far right-hand column, I have a cell for when a re-write is submitted. I put an "X" in the cell when a re-write is needed, and the date submitted when it's turned in. I'd like to put some conditional formatting on the report number cell so it becomes one color if there's an "X" in the re-write cell, and another color if there's a date in the re-write cell. Is this possible? Ed Select report number cell Menu Format>Conditional Formatting Change Condition 1 to Formula Is Add a formula of =M1="X" Click the Format button Select the Pattern Tab Select an appropriate highlighting colour OK OK Second condition Click Add Change Condition 2 to Formula Is Add a formula of =ISDATE(N1) Click the Format button Select the Pattern Tab Select an appropriate highlighting colour OK OK Change M1 and N1 to suuit  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >I have a spreadsheet that tracks reports. In a far right-hand column, > I have a cell for when a re-write is submitted. I put an "X" in the [quoted text clipped - 7 lines] > > Ed Bob: I'm in XL2003. I don't seem to have an ISDATE function??? I have the Analysis toolpack loaded. Ed > Select report number cell > Menu Format>Conditional Formatting [quoted text clipped - 39 lines] > > - Show quoted text - Nor do I <g> I should have said Add a formula of =IsADate(N1) and included that function Function IsADate(inDate) IsADate = IsDate(inDate) End Function SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Bob: > [quoted text clipped - 47 lines] >> >> - Show quoted text - There is no such thing since dates are numbers you can use =ISNUMBER(N1) SignatureRegards, Peo Sjoblom > Bob: > [quoted text clipped - 47 lines] >> >> - Show quoted text - I bet Bob created his own user defined function called =isdate(). But you may be able to use this formula instead: =AND(ISNUMBER(n1),LEFT(CELL("format",n1),1)="D") > Bob: > [quoted text clipped - 46 lines] > > > > - Show quoted text - SignatureDave Peterson Thanks for all the input. Between all of this, I have managed to get up and running. Appreciate the boost. Ed > I bet Bob created his own user defined function called =isdate(). > [quoted text clipped - 58 lines] > > - Show quoted text - >I bet Bob created his own user defined function called =isdate(). > > But you may be able to use this formula instead: > > =AND(ISNUMBER(n1),LEFT(CELL("format",n1),1)="D") That's quite clever. |
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.