Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting cells beginning with certain numbers
Hi all
I have a worksheet consisting of numerous telephone numbers - some are business and some are private. I have to find all those numbers which are private and highlight them. I realise that Excel won't be able to identify what is work and what is private so I could enter a code beside each cell that is a work number, thus the rest must be privat.e If i did it this way, how would I ask Excel to highlight all those cells that are private numbers? Hope this makes sense......... Thank you. Louise |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting cells beginning with certain numbers
Format ConditionalFormat and follow the menus......this feature cancolor
the background of cells, change the font color and/or add borders to cells, depending on your conditions........give it a try and post back with the details if you run into problems. Vaya con Dios, Chuck, CABGx3 "Louise" wrote: Hi all I have a worksheet consisting of numerous telephone numbers - some are business and some are private. I have to find all those numbers which are private and highlight them. I realise that Excel won't be able to identify what is work and what is private so I could enter a code beside each cell that is a work number, thus the rest must be privat.e If i did it this way, how would I ask Excel to highlight all those cells that are private numbers? Hope this makes sense......... Thank you. Louise |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting cells beginning with certain numbers
I did actualy try this but couldn't get it to work exactly as I want it to
but don't know if I'm asking for too much. If I have the word 'private' in a cell A1 and the actual telephone number in B1, how can I ask it to highlight 'private' AND the number in column B if the criteria is met? I have got it to highlight the cells containing the text in column A, but is there any way of extending the highlight to the actual number next door, so I don't have to do it myself? Hope this makes sense. "CLR" wrote: Format ConditionalFormat and follow the menus......this feature cancolor the background of cells, change the font color and/or add borders to cells, depending on your conditions........give it a try and post back with the details if you run into problems. Vaya con Dios, Chuck, CABGx3 "Louise" wrote: Hi all I have a worksheet consisting of numerous telephone numbers - some are business and some are private. I have to find all those numbers which are private and highlight them. I realise that Excel won't be able to identify what is work and what is private so I could enter a code beside each cell that is a work number, thus the rest must be privat.e If i did it this way, how would I ask Excel to highlight all those cells that are private numbers? Hope this makes sense......... Thank you. Louise |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting cells beginning with certain numbers
Highlight the cells in column B and click Format | Conditional Format
and choose "Formula Is" rather than "Cell Contents Is". Then in the next panel enter this: A1="Private" and click the Format button - choose the Patterns tab if you want to change the background colour and pick an appropriate colour. Click OK twice to get out of this, and your private calls should all have the phone number highlighted in column B. Hope this helps. Pete |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting cells beginning with certain numbers
Actually in this case, you will want to make the column absolute, otherwise
it will just highlight what is in column A. Make a slight change to the formula: =$A1="Private" -- Kevin Vaughn "Pete_UK" wrote: Highlight the cells in column B and click Format | Conditional Format and choose "Formula Is" rather than "Cell Contents Is". Then in the next panel enter this: A1="Private" and click the Format button - choose the Patterns tab if you want to change the background colour and pick an appropriate colour. Click OK twice to get out of this, and your private calls should all have the phone number highlighted in column B. Hope this helps. Pete |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting cells beginning with certain numbers
that should work a treat.
Thanks everybody. "Kevin Vaughn" wrote: Actually in this case, you will want to make the column absolute, otherwise it will just highlight what is in column A. Make a slight change to the formula: =$A1="Private" -- Kevin Vaughn "Pete_UK" wrote: Highlight the cells in column B and click Format | Conditional Format and choose "Formula Is" rather than "Cell Contents Is". Then in the next panel enter this: A1="Private" and click the Format button - choose the Patterns tab if you want to change the background colour and pick an appropriate colour. Click OK twice to get out of this, and your private calls should all have the phone number highlighted in column B. Hope this helps. Pete |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting cells beginning with certain numbers
You're welcome.
Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum numbers in cells that have text? | Excel Worksheet Functions | |||
enter numbers in blank cells | Excel Worksheet Functions | |||
How can I display numbers beginning with zero? | Excel Discussion (Misc queries) | |||
Cells as text not numbers??? | Excel Discussion (Misc queries) | |||
check if 2 cells are equal but only if they contain numbers not i. | Excel Worksheet Functions |