A story only I don't know

Google sheets can be conditionally formatted like Excel. Conditional formatting is the ability to change the style of a cell or line when the content of a cell meets certain conditions. a conditional form Conditional formats can be divided into two main categories. General conditional format to change the style of one's own cell if the conditions are met There is a custom formula that can be applied with various conditions and formats. General Conditional Format General conditional formatting has the advantage of being able to set conditions simply. However, you can format only your own cells. The conditional format is to mark the cell if the score is less than or equal to 50 points in the columns A. Conditions can conveniently specify different conditions for text, dates, and numbers at once, but the formatting range is reflected only in those cells. For example, if you want to format the entire row that corresponds to the cell's condition, you must use custom f...

Hello. I will explain about making a drop-down list on the Google sheet. The drop-down list is used in various places. I'm going to explain it as an example that applies to the itinerary. There are two main ways to use the drop-down list. One of them is to make it using a legend, and one is to make it by entering the item yourself. 1. How to make using a legend The most commonly used method is to create a separate legend sheet, create a list, and connect it. ▲ I'm going to apply the date. As shown above, you can see that the drop-down list has been applied from Day 1 to Day 5 ▲ You make a sheet called legend and you refer to the item here and bring it up. How to make it Drop-down lists can be created using the Data > Data Verification feature. First, select the item with the date Select Data from the top menu bar. Select Check Data at the bottom. Cell range is the location of the cell to which the corresponding drop-down list applies. You can specif...

I tend to use Google products a lot. My main calendar is also Google Calendar. As I became an executive of the group this time, I had to register my members' birthdays on the calendar. While I was just registering one by one, "What am I doing right now?" I'm starting to feel that kind of shame. The thought of registering the date information (birthday) on the Google sheet at once easily crossed my mind. So I looked it up and... I think it'll be possible if I write a little macro program. So I worked hard to develop it. It took 8 hours to register in an hour, so I made a program. As a result, it was more inefficient. crying But... It was inefficient for me, but I think it could be of great help to others if I disclose this code, so I'm going to reveal the code. Supplies All you need is a Google spreadsheet and a Google calendar. Of course, it's free. Google Calendar First, create a Google Calendar or prepare the calendar you are using. ... on the...