Excel - 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
Jacob Skaria replied to Telford Tom
Try the below formula instead which will validte blanks.
=AND(A1<>"",TODAY()-A1>=90)
If this post helps click Yes
---------------
Jacob Skaria
Excel 2007 won't open Excel 2003 Excel 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
Deleating All Selected Data Excel 2007 Excel Excel 2007 (What worked for Excel 2003 makes 2007 crash). I have run Microsoft Office Diagnostics and it can not identify any problems) When either by selecting columns or a specific group of cells and then click on delete Excel 2007 crashes - but worked in Excel 2003. Data to be deleted was copyed and pasted
What are the differences between excel 2000 & excel 2007? Excel We're trying to decide if it would be beneficial to upgrade from excel 2000 to excel 2007. What are the differences between excel 2000 & excel 2007? Excel Miscellaneous Discussions Microsoft Excel (1) Excel 2007 (1) BA597438D5D2 (1) Previews
Hyperlinks in Excel 2007 Excel What are the shortcut keys to "Open Hyperlink" in Excel 2007? Excel Miscellaneous Discussions Hyperlinks (1) Excel 2007 (1) FlowerGirl (1) ctrl+k keywords: Hyperlinks, in, Excel, 2007 description: What are the shortcut