Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change font color for cells starting with "T "
Hi guys,
I have multiple columns of data in which there are many occurences of a certain object. These values start with "T" and then there's a space and then a code/ date [looks something like T APR01/07, or T 09102007]. I was wondering if someone could help me with a macro that changes the font color for the columns between H and AG for cells starting with T and space, and change the color of the values to teal (plus bold it). I tried conditional formatting, but it doesn't have anything for cells beginning with a certain value. Thanks, Pman. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
change font color for cells starting with "T "
You can use Conditional Formatting, say in A1:
Formula Is: =LEFT(A1,2)="T " and then set your desired formats -- Gary''s Student - gsnu200750 "Pman" wrote: Hi guys, I have multiple columns of data in which there are many occurences of a certain object. These values start with "T" and then there's a space and then a code/ date [looks something like T APR01/07, or T 09102007]. I was wondering if someone could help me with a macro that changes the font color for the columns between H and AG for cells starting with T and space, and change the color of the values to teal (plus bold it). I tried conditional formatting, but it doesn't have anything for cells beginning with a certain value. Thanks, Pman. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
change font color for cells starting with "T "
Gary''s Student wrote:
You can use Conditional Formatting, say in A1: Formula Is: =LEFT(A1,2)="T " and then set your desired formats Or, if some cells'value may be t =EXACT(LEFT(F8,1),"T") Alan Beban |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
change font color for cells starting with "T "
Thanks Guys :)
Was able to do it with a macro :) Columns("H:AF").Select With Application.ReplaceFormat.Font .FontStyle = "Bold" .Subscript = False .ColorIndex = 13 End With Selection.Replace What:="T *", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=True Thanks again :) "Alan Beban" wrote: Gary''s Student wrote: You can use Conditional Formatting, say in A1: Formula Is: =LEFT(A1,2)="T " and then set your desired formats Or, if some cells'value may be t =EXACT(LEFT(F8,1),"T") Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup and bring the "font color" of the cell across? | Excel Worksheet Functions | |||
in Excel: How do I change "selected cells" highlight color? | New Users to Excel | |||
Different Font Color for results evaluated by "IF" | New Users to Excel | |||
Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it? | Excel Discussion (Misc queries) | |||
How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help. | Excel Programming |