![]() ![]() Part of my worksheet is formatted with All Borders. version 2003, working in the same workbook now for quite some time, has stopped the ability to click and drag the formulas down the sheet, only copies the value of the first cell. I have a Google Sheet with conditional formatting that changes the background color of cell H2 based on the contents of cell F2.I want to auto-fill this conditional formatting rule down the column, so that cell H3 depends on F3, H4 on F4, and so on. ![]() Scroll all the way down and click Show Advanced Settings. The same thing works for other information, basically anything that can be powered with Google Sets, and you can force Google Spreadsheets to always use Google Sets for the information by holding down the Ctrl key. Enter this formula in the first cell: =CONCATENATE ("Q_",ROW ()) Select the first cell again. In the drop-down menu that appears, select Settings.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |