I’ve set up a Google Sheet for managing clinic appointments and need assistance with a way to automatically highlight a specific cell or an entire row depending on the client’s name. I’m open to using either a script or another Google Sheet for this function.
For instance, I would like the following names highlighted when they are entered:
- John Doe
- Susan Davis
- Edward Johnson
Whenever a name is input in the ‘Name’ column, the corresponding row or cell should change color.
Any guidance would be greatly appreciated. Thank you!
An effective approach to automatically highlight rows or cells is to use conditional formatting in Google Sheets. First, select the range that you want to apply the formatting to. Under the Format menu, choose ‘Conditional formatting.’ Then set a custom formula rule; for example, use =OR($A1=“John Doe”,$A1=“Susan Davis”,$A1=“Edward Johnson”) if your ‘Name’ column is A. Choose a formatting style like a background color to apply when the conditions are met. This should automatically highlight the specified names without requiring any scripting.