Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find cells with a specific character in them and conditionally format cell
Hi
I want to format all rows in which the first cell in the row has a comma in it somewhere. Part of code only below: A compile eror occurs at Find? For Each cell In RefNoRange 'loops through each cell in the reference number range If IsError(Find(",", cell)) Then Else 'looks for a comma in the ref number, With cell.EntireRow .RowHeight = 32 .VerticalAlignment = xlCenter '.Font.ColorIndex = 1 'black .Font.ColorIndex = 5 'blue .Font.Size = 14 .Font.Name = "comic" .Font.Bold = True .Font.Italic = True Any help would be gratefully received Ritchi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find cells with a specific character in them and conditionally for
If InStr(cell.Value, ",") 0 Then
-- Gary's Student gsnu200705 "RITCHI" wrote: Hi I want to format all rows in which the first cell in the row has a comma in it somewhere. Part of code only below: A compile eror occurs at Find? For Each cell In RefNoRange 'loops through each cell in the reference number range If IsError(Find(",", cell)) Then Else 'looks for a comma in the ref number, With cell.EntireRow .RowHeight = 32 .VerticalAlignment = xlCenter '.Font.ColorIndex = 1 'black .Font.ColorIndex = 5 'blue .Font.Size = 14 .Font.Name = "comic" .Font.Bold = True .Font.Italic = True Any help would be gratefully received Ritchi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I conditionally format 1 cell to look at 5 cells | Excel Discussion (Misc queries) | |||
Format cell to accept only specific character-reject others | Excel Discussion (Misc queries) | |||
formatting a specific character or number in each cell within a rangeof cells | Excel Programming | |||
how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions |