| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check matching value
Hi,
How can i check that a value in one cell with respect to a range of cells that the value/text is found in the range and vice versa and that the font in the cell has a strikethrough font. thanks. regards, ben |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check matching value
For the first question, use Application.MATCH or Application.VLOOKUP (syntax
for either is the same as for the worksheet functions), or VBA Find. For the font, look up the Font object in VBA Help. You'll see it has many properties, one of which is StrikeThrough. On Thu, 4 Nov 2004 18:32:01 -0800, Ben wrote: Hi, How can i check that a value in one cell with respect to a range of cells that the value/text is found in the range and vice versa and that the font in the cell has a strikethrough font. thanks. regards, ben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching check to payment amounts | Excel Worksheet Functions | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| matching Check # for Bank Reconciliation through Excel | Excel Worksheet Functions | |||
| How to check matching strings in 3 columns | Excel Discussion (Misc queries) | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Linear Mode
