msgbox Range("A1").Value

You secod question is much more difficult (assuming the font color is being
produced by conditional formatting) and can only be achieved in a
round-about way.

See Chip Pearson's page on this topic:
http://www.cpearson.com/excel/CFColors.htm

--
Regards,
Tom Ogilvy

"jgreif" <jgreif.1pk8yn@ wrote in message
...

Using the Excel object model (in Excel 2003), how can one obtain the
current value from a cell containing a formula? Similarly, how can one
obtain the current font.Color of a cell whose color is determined by a
conditional format?


--
jgreifPosted from http://www.pcreview.co.uk/ newsgroup access