LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default Search column...change row to BOLD

Sub dj()
For Each c In Range("A2:A11")
If c.Value = Int(c.Value) Then
c.Font.Bold = True
End If
Next
End Sub



"Mike" wrote in message
...
I'm an amateur excel user and I've just taught myself how to create a
macro.
I have a bid program that I export a summary sheet to excel. I've set up
a
macro to format column widths and column colors. I want to add to this
macro
to search column A for WHOLE numbers. If the cell in column A is a whole
number, then I want to change that row to bold. Help please?



 
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
Search column...change row to BOLD Don Guillett Excel Programming 1 June 19th 09 12:48 AM
Search and change font color to Red and bold it CAM Excel Programming 1 June 28th 08 08:19 AM
Search for Change in a column. INTP56 Excel Programming 2 January 10th 08 01:14 AM
Tough One - search for string and BOLD it. JakeyC Excel Programming 0 January 11th 07 07:21 PM
Using [bold] as a criterion to search tevia Excel Discussion (Misc queries) 4 March 17th 06 02:59 PM


All times are GMT +1. The time now is 09:43 AM.

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

About Us

"It's about Microsoft Excel"