| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting of cells containing text
Hi!
In Excel 2003, I have a column looking like this: CORP-SOP-0012 CORP-WI-0123 CORP-SOP-0034 CORP-WI-0165 How can I make all the cells beginning with "CORP-SOP" one colour and all the cells beginning with "CORP-WI" another? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting of cells containing text
1. Suppose the data is in Column A. Select Column A.
2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =FIND("CORP-WI",A1) Click Format ButtonPattern and select your color (say Red) 4. Click on Add button. 5. For Condition2Select 'Formula Is' and enter the below formula =FIND("CORP-SOP",A1) 6. Hit OK If this post helps click Yes --------------- Jacob Skaria "Elin" wrote: Hi! In Excel 2003, I have a column looking like this: CORP-SOP-0012 CORP-WI-0123 CORP-SOP-0034 CORP-WI-0165 How can I make all the cells beginning with "CORP-SOP" one colour and all the cells beginning with "CORP-WI" another? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting of cells containing text
You need two conditions with each condition using FORMULA IS
=LEFT(A8,9)="CORP-SOP-" =LEFT(A8,8)="CORP-WI-" "Elin" wrote: Hi! In Excel 2003, I have a column looking like this: CORP-SOP-0012 CORP-WI-0123 CORP-SOP-0034 CORP-WI-0165 How can I make all the cells beginning with "CORP-SOP" one colour and all the cells beginning with "CORP-WI" another? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting of cells containing text
Thank you for putting me on track, it did not exactly work. I had to use this
formula to make it work correctly: =LEFT(A1;9)="CORP-SOP-" But that was just a small matter of trial and error :-) Thanks! Elin "Joel" wrote: You need two conditions with each condition using FORMULA IS =LEFT(A8,9)="CORP-SOP-" =LEFT(A8,8)="CORP-WI-" "Elin" wrote: Hi! In Excel 2003, I have a column looking like this: CORP-SOP-0012 CORP-WI-0123 CORP-SOP-0034 CORP-WI-0165 How can I make all the cells beginning with "CORP-SOP" one colour and all the cells beginning with "CORP-WI" another? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting of cells containing text
Format/Conditional Formatting/ Formula Is (not cell value is)/
=LEFT(A2,8)="CORP-SOP" choose your first colour Add/ Formula Is / =LEFT(A2,7)="CORP-WI" choose your second colour -- David Biddulph "Elin" wrote in message ... Hi! In Excel 2003, I have a column looking like this: CORP-SOP-0012 CORP-WI-0123 CORP-SOP-0034 CORP-WI-0165 How can I make all the cells beginning with "CORP-SOP" one colour and all the cells beginning with "CORP-WI" another? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on text status of 3 cells | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional Formatting in for Cells with Mixed Dates and Text | Excel Worksheet Functions | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| conditional formatting on specific text in cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
