Conditional Formats XL2007
Asked By Telford Tom
21-Nov-09 05:22 AM
Sorry, it must be me. This did not work, things just went straight to Red even
though they are not out of date. In the formula =TODAY()-A1>=90 should I be
typing anything in between the brackets?
Telford Tom
Try the below formula instead which will validte blanks.
Jacob Skaria replied to Telford Tom
21-Nov-09 07:13 AM
Try the below formula instead which will validte blanks.
=AND(A1<>"",TODAY()-A1>=90)
If this post helps click Yes
---------------
Jacob Skaria
Excel Excel 2007 won't open Excel 2003 I'm having an odd problem with my Excel 2007. Excel 2007 will not open my Excel 2003 files by double clicking on them. I tried to associate the Excel 2003 with Excel 2007, but I think I got the
Excel Excel 2007 encryption type? What is the default encruption type for Excel 2007? Excel 2003 and before had and advanced option that would allow an encryption type. How do you get to this in Excel 2007 when you are saving files in the legacy 2003 file t believe they took away the menu's in Office 2007. keywords: Excel, 2007, encryption, type? description: What is the default encruption type
Excel Excel 2007 undo hazard Hi all, I recently started using Excel. . . Excel 2007 actually. . . and one thing I've noticed is that when you have several spreadsheets open in one Excel 2007 instance and repeatedly invoke undo. . . expecting that it will only know how to disable that particular "feature" and / or force Excel to use a separate instance for each spreadsheet? Not new. Beware your expectations. An 2007 change undo change is that a file, save does not
Excel excel 2007 - excel 2003 Dear All, i am using excel 2007. but when i noticed that i cannot save the files decided to go back to 2003. when i installed ONLY excel 2003 from the 2003 CD, it worked and opened all the excel sheets in 2003. all the rest like access, word outlook was still operating well in 2007. . . until office 2007, like 30 minutes later, started "office 2007 configuration", so it
Excel Excel 2007 & Excel 2003 sharing server How do I stop 2003 spreadsheets automatically opening in Excel 2007?? I currently run a Win 2003 server with Office 2003 installed.i have recently installed Office 2007 . I need spreadsheets created in Excel 2003 to be opened (by default) with Excel 2003. At the moment if I double click on a spreadsheet ANY spreasheet Excel 2007 opens it. I have tried changing the file association
Excel Excel 2007 column limit I have both excel 2003 and excel 2007 which is part of MS office enterprise 2007 installed on my computer. I was told that the new excel 2007 can support column limit 16, 384. but I found it You are in 2003 mode. Are you looking at an Excel 2003 workbook in Excel 2007? If you are you'll
Excel Excel 2007 compatibility message Where I work, some people are using Excel 2003, some use Excel 2007, and some use Excel 2004 on a Mac. The people using Excel 2007 save their files in Excel 97-2003 format. I have noticed that when an Excel
Excel Excel 2007 does not recognize printer. Word 2007 does I have an associate that can print succesfully to an HP K5400 Color printer through XP, Word 2007, Outlook 2007, and PowerPoint 2007. Excel 2007 states that it does not recognize the printer. I have Excel12 and still have the same results. - - MCSE, A+ keywords: Excel, 2007, does, not, recognize, printer., Word, 2007, does description: I