Jun 29, 2020 ... I am looking for a specific formula I have not been able to create. I need the sum of every number in an odd row in the column, starting in row 3.

Apr 12, 2019 ... I've tried only selecting the rows underneath the ones that already have the colours set, but I get the same error. I've also cleared all ...

May 16, 2023 ... Now copy the range B4:B5, then select the range below B4:B5, and click paste. You would do the same technique for all other columns. Diamond ...

Mar 16, 2019 ... You should be able to just select all of H6:H49 and make it one color, then apply this cond. formatting rule to that same range: =MOD(ROW(H6)- ...

Mar 10, 2022 ... Using the conditional formatting tool, I selected the appropriate range, Custom formula is, and then input =ISODD(range) and ISEVEN(range) in ...

Jan 8, 2022 ... My aim is to use a query to select all of the rows where the quantity column contains a number. ... cells so this is a pretty odd behavior.

Jul 8, 2019 ... ... select Col1, Col2, Col3, Col4 ... The fact that your import started at row 66 looked odd but it should retrieve all rows 66 and later.

May 4, 2019 ... Note that I am not looking to alternate row colors. I tried using Conditional formatting > Custom Formula is > with formula: =MOD(B1:B99,2)*1 ...

Apr 9, 2020 ... It filters every 5th row. Select the links and hit Alt+Enter. Hope this helps?

I believe a form or time trigger will process all rows. Joe Schmidt. GLUA ... Odd row gets stuck with "Starting at..." and autocrat would not complete ...

Aug 11, 2019 ... If the selection initially has of rows of different heights, changing the height of the entire selection will make the rows all the same height.

May 8, 2019 ... That is odd. I don't know why it treats H different than G. But ... select the data including row 1 if you want it used as a header.

Sep 27, 2019 ... What I found is if I select a range and add a custom style it remains in that list. ... All Replies (7). Ben Liebrand. Diamond Product Expert.

Apr 9, 2019 ... Highlight all the columns you're looking for by dragging across the column letters themeselves, up above the top row of the sheet.

that's almost right: in the snapshot I posted of my table, I want my script to start on row 3 (skipping the headers) and identify where the columns are odd ( ...

Oct 25, 2022 ... Hi there – I am trying to hide the contents of all the cells in this worksheet that contain the date "1/30/2060." I don't want to get rid of ...

Jun 29, 2019 ... It's just an odd interface issue that is affecting exactly one user - lol YOU! ... highlight all your cells and repaste a formula and it will now ...

Mar 12, 2019 ... I have a project tracking sheet with 18 columns and almost 1000 rows. I'd like to have custom views for different sets of those 18 columns.

Apr 3, 2019 ... Right click on the row number and select Resize Row. You can also select multiple rows at once then right click on any of the selected row numbers and resize ...

Dec 17, 2021 ... * - take a backup of your spreadsheet through File > Make a copy * - select all the text in this script, starting at the first "/**" * line ...