Thread: Formating excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Formating excel

If frames mean borders, it sounds like:
Format|conditional formatting may do what you want.

Debra Dalgleish has some notes at:
http://contextures.com/xlCondFormat01.html


Bent Lauridsen wrote:

Hi All

is there anyone that can help me with a little problem.

I would like to hear, if there is anyone of you that can tell me if it is
possible to get excel to make frames in a cell depending of the contens.

ex.
if I in a cell have a SUM() function that result in a value 10000 then
there should be a frame in the top of the cell, and if it is 15000 then
both a frame in top and one in the bottom of the cell.

Yours

Bent Lauridsen / Bamsefar


--

Dave Peterson