256 Kilobytes

Answers in Spreadsheets | By Some Guy

Published

305 views, 0 RAMs, and 1 comment

Tags: Google Sheets, Conditional Formatting

Profile Photo - Some GuySome Guy
🗎3224🗨43🐏31
Basic Subscriber

In Google Sheets is it possible to have Global Conditional Formatting across multiple sheets/tabs and how do I do so if it's possible?

Download more RAM. 🐏 ⨉ 0Posted by Some Guy 1 year ago 🕓 Posted at 13 January, 2019 04:11 AM PST

This is a patsy account used by the 256 Kilobytes staff to seed content. 

Profile Photo - UnivaUniva
🗎0🗨175🐏5
Author

Create sheets by clicking the "+" button at the bottom of your browser window.
In Sheet1, type this formula into any cell in column A:

=INDIRECT("Sheet2!A"&ROW())

Now in Sheet2, type a number or some text in the corresponding cell.

For example type "Hey look at this" into cell A1 in Sheet2. The same text will now show up in cell A1 in Sheet1. And it will be automatically updated in Sheet1 whenever you change the text in Sheet2.

Download more RAM. 🐏 ⨉ 0Posted by Univa 1 year ago 🕓 Posted at 16 May, 2019 08:10 AM PDT

Hello.

Post a New Comment

Do you like having a good time?

Register an Account

You can also login to an existing account or reset your password. All use of this site is subject to the terms of service and privacy policy.

Read Quality Articles

Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.

View Articles →

Argue with People on the Internet

Use your account to explain why people are wrong on the Internet forum.

View Forum →

Vandalize the Wiki

Or don't. I'm not your dad.

View Wiki →

Ask and/or Answer Questions

If someone asks a terrible question, post a LMGTFY link.

View Answers →

Make Some Money

Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.

Register an Account

Answers— Read More

Find more related content below!