Strike-through an entire row.

MS EXCEL

    Sponsored Links

    Next

  • 1. Sandwich existing formulas with "If iserror(formula),0,formula)"
    Hi, I have several hundred different formulas on one spreadsheet like this one. =VLOOKUP($C$1,'P:\Rate Sheets\client name\[file name.xls]manager name'!$BV$67:$CL$131,3,FALSE) The results sometimes return #DIV/0!, or other error messages which ruin my attempts at summing the results as well as the visual appeal. Is there a way to rewrite (en masse) these formulas to so that they first check "If(iserror(myformula),[then] 0, [else] myformula) so that rather then an error result I will see a zero (0).? I can manually change them but that would take a day at least. Please let me know. Thank you, Orlando
  • 2. Sandwich existing formulas with "If iserror(formula),0,formula)"
    If you are getting a #DIV/0! error from your VLOOKUP, then the error is in the workbook where you are getting the data from, rather than in the VLOOKUP formula itself. Consequently, you should look at the "sending" workbooks and eradicate any errors that are in there. Hope this helps. Pete On Dec 23, 4:36m, ORLANDO VAZQUEZ < XXXX@XXXXX.COM > wrote: > Hi, > > I have several hundred different formulas on one spreadsheet like this one. > > =VLOOKUP($C$1,'P:\Rate Sheets\client name\[file name.xls]manager > name'!$BV$67:$CL$131,3,FALSE) > > The results sometimes return #DIV/0!, or other error messages which ruin my > attempts at summing the results as well as the visual appeal. > > Is there a way to rewrite (en masse) these formulas to so that they first > check "If(iserror(myformula),[then] 0, [else] myformula) so that rather then > an error result I will see a zero (0).? > > I can manually change them but that would take a day at least. > > Please let me know. > > Thank you, > Orlando
  • 3. scale to page error in Excel 2007
    somehow something has changed in my Excel 2007 setup where my "fit to scale" does not work appropriately. When I choose print preview, the preview screen changes to a very small preview and my document is a few thousand pages. This document used to print fine on one page. Even on my other computer it prints fine. The funny thing is, when I change it back to 100% scale the preview is large again but still cuts off a few columns. I must have changed some setting that I need to reset but cannot find it. Any help is appreciated.
  • 4. how look up this way?
    Thanks for any help. I would like to look up an array like this: A1-D1:Def Per x yrs,2008,2009,2010 A2-A5:0<x<=5,5<x<=10,10<x<=20,20<x<=120 (these could just be labels, with numbers like 5, 10, 20 & 120 to a column to the right for the lookup, if necessary, but if the formula could use these for lookups, that's fine too) B2-D5:the look up values, let's say: 1,2,3,4,5,6,7,8,9,10,11,12 (by row then by col. So C3 is 6). I would like to look up for 2008 & 0<x<=5 (so x might be 1 or 2.5 for example) is 1 2008, 5<x<=10 is 2 2008,10<x<=20 is 3 2008,20<x<=120 is 4 2009,0<x<=5 is 5 2009,5<x<=10 is 6 etc I would like to do this with a nested look-up/search/find statement, rather than a bunch of ifs, or even one if. I tried: =VLOOKUP(x,A2:D5,MATCH(year,A1:D1)) 'and remember, the A2-A5 is not '0<x<=5, etc, but 5 10 20 120. but I couldn't get this to work. Any ideas? thanks again.
  • 5. Update date & time in a cell only when worksheet is changed
    I have a workbook with multiple worksheets. I'd like to have the time & date in a cell in each worksheet update only when information in that worksheet is changed. I don't change each worksheet each time I use the workbook. I tried =NOW(), but it changes the time and date in each worksheet.

Strike-through an entire row.

Postby HoundofCullin » Wed, 21 Jan 2004 08:31:51 GMT

OK... I need to know if there is a way I can strike through the text on
a row by highlighting the row with the defunkt information and
activating a macro.

Let's see if I can give an example.


Say I'm entering data in, row by row... Each row's data is SIMILAR but
not the same. 
Now let's say that apon review I notice that one of the row is
incorrect.
I need to be able to highlight the row (Presumably by selecting the
corresponding number on the left hand side {1,2,3 etc}) then I need to
run a macro (that will eventually be tied to a button) and then be done
the macro would turn the text .RED  and then strike through the
information. Is that even possible? if so... can you help me?!


Thanks a ton, Josh


---
Message posted from  http://www.**--****.com/ 


Re: Strike-through an entire row.

Postby Earl Kiosterud » Wed, 21 Jan 2004 08:46:11 GMT

Josh,

You can select an entire row with Shift-Space too.  The following code will
make the entire row red (that the cell pointer is in).

Sub RedStrike()
    With Selection.EntireRow.Font
      .Strikethrough = True
      .ColorIndex = 3
      End With
End Sub

I did this by recording a macro, then taking out a bunch of stuff and
tweaking it a bit.  You may wish to assign a shortcut to run it quickly from
the keyboard.  Tools - Macro - Macros.  Select the macro, and click Options.
There's a place to put in a shortcut.  I used Shift-R.  It wound up
Ctrl-Shift-R.  The Excel shortcuts don't use Shift, AFAIK.

-- 
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"HoundofCullin >" << XXXX@XXXXX.COM > wrote in





Similar Threads:

1.Error--"try selecting only entire rows, entire columns, or just groups of cells"

I've looked online for help and found the following.  I tried following the
directions, but it doesn't seem to do anything.  The original row shows 2
selected rows (even when I try to select only one to delete the other) and
when I follow these directions, it inserts 2 rows.  :

>  That command cannot be used with selections that contain entire rows or
> columns, and also other cells.
> Try selecting only entire rows, entire columns, or just groups of cells.
> CAUSE
> This behavior occurs when all of the following conditions are true:
> 
> €    You merge cells in a column or row. -and-
> 
> €    You select the entire column or row in which you merged cells. -and-
> 
> €    The column or row that you select contains a merged cell that extends
> over another column or row that you do not select. -and-
> 
> €    You click Columns or Rows on the Insert menu.
> RESOLUTION
> To resolve this behavior, select a single cell in the column or row in which
> you merged cells (not the entire column or row), and click Columns or Rows on
> the Insert menu. 


Michelle York
Literacy Coach (1-5)
Highland Park Central Elementary School
Topeka, Kansas

2.Row and Column Strikethrough

  Why are my Row and Column Headers shown with a Strikthrough each of the 
letters and numbers?
  I can email a screen shot in PDf if anyone would like to see.

Thansk,
Craig

3.remove rows that have any cells values strikethrough to a blank Sheet2

4.delete rows that have strike-through values in column A

5.Strikethrough cells B2 to E2 (a "row", in essence) when A2 has a c

Place this code in the "sheet" module that corresponds to the sheet you want 
to monitor.

Regards,
Bill


Private Sub Worksheet_Change(ByVal Target As Range)
    Dim strAddress                  As String
    Dim rngFormat                   As Range

    If (Target.Cells(1).Column = 1) Then
        strAddress = "B" & Trim$(Target.Cells(1).Row) & ":E" & 
Trim$(Target.Cells(1).Row)
        Set rngFormat = Target.Parent.Range(strAddress)
        
        If (Len(Target.Cells(1).Value) = 0) Then
            rngFormat.Font.Strikethrough = False
        ElseIf (Asc(Target.Cells(1) = 118)) Then   ' 118 is the ascii code 
for the sq rt symbol
            rngFormat.Font.Strikethrough = True
        End If
    
        Application.Calculate
    End If

End Sub



"StargateFanFromWork" wrote:

> The reason this is tricky is because all the other columns have all 3
> possible conditional formatting slots taken, so it seems one would need to
> use code for this.
> 
> I use the square root symbol (representing a checkmark) in a pulldown menu
> in column A.  So column A is either empty or it has this symbol.  When
> empty, nothing happens; but if user chooses this "checkmark" symbol, the
> cells in column B to E of that row should then have a strikethrough applied
> to the text in that row.  Also, where would one put the vb code to do this?
> I've searched the archives but so far no mention has been made on where this
> type of code to augment conditional formatting should go.
> 
> tia   :oD
> 
> 
> 

6. strikethrough row number

7. Row-Entire row changes color (and stays) selecting first entry

8. i want to highlight entire row when selecting a cell in that row



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 82 guest