View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
kassie kassie is offline
external usenet poster
 
Posts: 515
Default Various Interpolation types in Excel

So sorry, this ended up with the wrong question, please ignore!
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Kassie" wrote:

Your info is ectremely limited, but yes, it can be done. Have you looked at
Conditional Formatting yet?

Say the one value is in B2, and the other value is in C2, then select the
all used cells in row 2, click on the Formatting menu on top, select
conditional formatting, change the Cell Value Is block to Formula is, and
type in B2=C2. Click on the Format button, select the Pattern tab, and set
the colour of your choice.

Alternatively, if you have Excel 2007, click on the conditional formatting
button, select the Hoghlight cells option, select Equal to, and enter =$C$2
--
Hth

Kassie Kasselman
Change xxx to hotmail


"Mohamed Badawy" wrote:

I'm trying to perform several types of interpolation similar to that of matlab:

1- Linear Interpolation
2- Linear Spline
3- Cubic Spline

Anyone can guide me to any documents to read or if any exists an Excel Add-in.
Please note I'm using Office-2003.

Thanks