LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default function formatting a cell

Suppose I have a value in A1 and the formula
=FormatCell(A1), calling the following macro, in B1

Function FormatCell(a As Range)
a.Cells(1, 1).Select
Selection.Font.Bold = True
Selection.Font.ColorIndex = 3
End Function

Why I hav'nt A1 formatted?
I have breakpointed the macro and it triggers when I change the A1
value.

Bye, Emiliano
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
use formatting from source cell in CONCATENATE function zacarab Excel Worksheet Functions 1 September 18th 06 11:25 PM
formatting a cell with a function (IF statement) Dreaming Excel Worksheet Functions 3 June 30th 05 02:26 AM
Formatting a cell with a function (IF statement) Dreaming Excel Worksheet Functions 2 June 30th 05 02:12 AM
Changing cell formatting with IF function Bruise Excel Worksheet Functions 6 May 21st 05 11:40 PM
How can I use an IF function to look for specific cell formatting. Tim Excel Worksheet Functions 1 November 15th 04 01:09 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"