View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default Excel 2007 question?

Are there any compatibility issues ...
For example, when the EDATE ...


Note that EDATE is now a built-in function, and not an Add-Inn. Yeah!!

Can't wait to install Excel 2007!


You are going to love the productivity improvements. :O
What took 0.3 seconds in earlier versions is now done like this.
When you need something, Click on each menu item in sequence...
<Home <Insert <PageLayout <Formulas <Data <Review <View <Developer

Can't find it! Do again...

<Home <Insert <PageLayout <Formulas <Data <Review <View <Developer

Repeat ad nauseam.

Hmmm. Still Can't find it.

No try the dreaded help file.
I have about a 20% chance of finding it here.
In vba help, the helpful Properties & Methods were remove.
etc, etc, etc.

Some friends entering College are not going to use office 2007 because of
this huge time waste.

Good luck, and have fun!!!
--
Dana DeLouis


"Dan the Man" wrote in message
...
Are there any compatibility issues when transitioning from Excel 2002 to
Excel 2007? I just bought 2007 but haven't installed it yet. I'll assume
that
all of my worksheets and formulas will work just the same? I'll also
assume
that if I send a 2007 spreadsheet to someone with an earlier version of
Excel, that they will be able to open the file without issue?

Btw, thought I also heard tht Excel 2007 has some incredible new
functions,
bells and whistles whcih include the ability to incorporate formulas that
can
also perform "countif" functons based upon color. That would be kewl. Does
Excel 2007 also allow logic formulas to be written which "change" the
color
of the font when certain parameters are met? For example, when the EDATE
function is employed, can logic be writen to change the color of the font
in
a particular row from black to red, once the applicable date has elapsed.
For
example if a formula is placed in cell AA3, can that formula include logic
to
change the font from black to red once the 3 month date elapses?

IF(A1="","",EDATE(A1,3)

or........

=countif (a formula which only counts certain color fonts or cell
shades?)

Can't wait to install Excel 2007!

Dan