sheet change background color, if data change using importrange.

[Jonas Hansen]

Hi

Is it possible to make a script there change background color, if data changes in cell using importrange from other sheet document.

[Keith Andersen]

Yes. What are your parameters? A single cell? Range? Row? Column?

When and under what condition do you want the formatting to occur?

On Wed, Feb 14, 2024, 4:16 AM 'Jonas Hansen' via Google Apps Script Community <google-apps-sc...@googlegroups.com> wrote:

Hi

Is it possible to make a script there change background color, if data changes in cell using importrange from other sheet document.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/8cce4519-44d2-4894-b73e-2996cabb30e9n%40googlegroups.com.

[Jonas Hansen]

Hi Keith

it is a range of cells with different data that I updated/retrieved with importanger from other sheets document.

I have one department there is updating one sheet with som dates and locations, and another department there is planning in the main document where they want the changed cell will be marked with red color, when there is an update/changed.

it the trigger could be when the document opened and every minute

[Keith Andersen]

Can you give an example of what you want to accomplish?

Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/948b3a33-f363-4db9-85a9-f053bbecac9an%40googlegroups.com.

[Jonas Hansen]

Hi Keith
users changes data in some cells in sheets document1, another department have sheets document2 with a lot of data, but some of the cells use Importrange "=IMPORTRANGE("path to document1","sheet1!a1")" to get data from document1 (that part works fine). I want to mark the changed cell using importrange red in document2.


Hope it makes sense.



thanks

[Keith Andersen]

Sorry. No specific data, conditions, ranges to advise on. Suggest looking at some videos on data validation.

Good luck 

Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/8c857e5a-2e10-49c6-8847-051db1e41794n%40googlegroups.com.