Google-sheets – How to format one cell to match formatting of another (even if “other” changes later)

formattinggoogle sheets

How can I do the Style equivalent of setting one cell equal to the style of another cell, even if the "other" cell style changes?

use Case:

I want all Row #2 of each sheet to look like (same style) as Sheet #1.

Best Answer

This is not possible to achieve by non-scripting means. A partial solution would be to edit header/footer of your spreadsheet. It can be accessed by pressing CTRL + P and editing custom fields:

Related Solutions

Google-sheets – How to apply formatting to a cell based on comparison with another cell

Here is what you can do:

RightClick B2 → select Conditional formatting → select Custom Formula is (from the List)
Enter the following formula in the textbox: =b2>=c2
Check the Background Color and select green color
Click on Add another rule
Select Custom Formula is (from the List)
Enter the following formula in the textbox: =b2<c2
Check the Background Color and select red color
Click on Save Rules
Highlight B2 and click on Paint Format option on the tool bar.
Now click on cell B3 and drag until cell - B117 (this should apply the conditional formatting on cell ranging from B3-B117)

And for your second condition (i.e., to highlight D with green if it is greater than or equal to E, red if it is less than E) - simply repeat the above steps by interchanging D2 for B2 and E2 for C2.

Google-sheets – How to enter a date in a cell and have the date for one week later automatically fill another cell

You can use this formula.

Formula

=ARRAYFORMULA(IF(ISBLANK(A2:A),"",A2:A + 7))

Screenshot

enter image description here

Example

I've created an example file for you: new date from entered date