Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Mike,
It sounds like you could use conditional formatting. First highlight the rows in question. Then in FormatConditional Formatting, choose "Formula Is". Assuming the first row is 2 and that A2 is the active cell, you'd enter this in the formula box: =$A2=Int($A2) Then click "Format" and choose Bold in the font section. hth, Doug "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? __________ Information from ESET NOD32 Antivirus, version of virus signature database 4168 (20090618) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4168 (20090618) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search column...change row to BOLD | Excel Programming | |||
Search column...change row to BOLD | Excel Programming | |||
Search column...change row to BOLD | Excel Programming | |||
Search and change font color to Red and bold it | Excel Programming | |||
Search for Change in a column. | Excel Programming |