In Google Sheets, is there a method to adjust the formatting of a cell, such as changing its background color, according to the specific user accessing the sheet?
I am utilizing Google Sheets for managing employee schedules and want to ensure that the name of the employee who is currently viewing the sheet is highlighted whenever it appears throughout the schedule.
For instance, if Tom accesses the document, I would like every cell containing “Tom” to have a distinct highlight. Conversely, if Bob checks the same document, all instances of “Bob” should be emphasized.
I appreciate any help you can offer!
From my experience, Google Sheets doesn’t natively allow dynamic formatting based on the specific viewer, which complicates your request. However, you might consider using different approaches like creating separate views or copies of the sheet tailored for each individual if the main objective is personal emphasis. This way, you can manually set the formatting according to the user. While it isn’t automated, it does ensure each person sees the correct highlights without involving complex coding or potential issues with scripts.
Hey, I don’t think it’s possible to change formats per user view directly in Sheets. A workaround could be using Google Apps Script, with a script to highlight names based on who’s logged in. It’s tricky and requires some coding skills though. Just an idea worth exploring. 