Calculations

Deon · Nov 16, 2003

Hi, i want to know if it is possible to calculate numbers in different
colours or numbers (in black) with different backgrounds.

ie. i only want to calculate numbers in red?

Any help will be appreciated.
T, DB

Chip Pearson · Nov 16, 2003

Deon,

You need to use VBA functions to do this. See
www.cpearson.com/excel/colors.htm for details and example code.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

J.E. McGimpsey · Nov 16, 2003

take a look here:

http://cpearson.com/excel/colors.htm

Bob Phillips · Nov 16, 2003

Deon,

Check out this previous post for a function that will help with your request

http://tinyurl.com/qmct

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Calculations

Deon

Chip Pearson

J.E. McGimpsey

Bob Phillips