Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
Is it possible to conditional format for specific terms within a cell.
e.g. the addition a letter or letters to a number will change the colour of the cell. 1A = Red 10B = Yellow 100AB = orange. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
E.g.
Formula for conditions: =LEN(cellref)=2 1A = Red =LEN(cellref)=3 10B = Yellow =LEN(cellref)3 100AB = orange. Regards, Stefi |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
Highlight your range
Conditional Formatting Condition 1: =A1="1A" (Format as red) Condition 2: =A1="10B" (Format as Yellow) Condition 3: =A1="100AB" (Fomat as Orange) "P Beardshall" wrote: Is it possible to conditional format for specific terms within a cell. e.g. the addition a letter or letters to a number will change the colour of the cell. 1A = Red 10B = Yellow 100AB = orange. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting
Is it just the letter that determines the colour, e.g. any cell ending "AB"
should be orange? If so use these conditions 1 =RIGHT(A1,2)="AB" orange 2 =RIGHT(A1)="B" yellow 3 =RIGHT(A1)="A" red "P Beardshall" wrote: Is it possible to conditional format for specific terms within a cell. e.g. the addition a letter or letters to a number will change the colour of the cell. 1A = Red 10B = Yellow 100AB = orange. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |