0

I would like to gray out a column (e.g., column H) based on who opened this document - as in based on the Google account that is viewing or editing this google sheet.

As you could see in the below picture, I want column H grayed out (not hidden but disabled for user input) when anyone else other than a specific person is viewing/editing it. enter image description here

0

1 Answer 1

2

Take a look at protecting ranges, it will provide with just what you need to avoid users from editing a particular range of the sheet. In short, it work similar to file permissions, you can assign edit permissions in particular ranges so that only you (assuming you're the file owner) can edit in that range.

As for the coloring, I would advise against this, it could be achieved with a script, but if two users have the Sheet open at the same time (one with permissions, one without) one of them will see the column in a way they shouldn't. If you set the protected ranges, they will see a window telling them they cannot edit that cell.

Sign up to request clarification or add additional context in comments.

1 Comment

Your solution for works great (protecting ranges). That's what I was looking for. What I meant by "grayed out" is not really the color but disabling the option to edit.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.