How to Find Out Whose Birthday is This Month in Google Sheets Quickly
Learn how to quickly identify and highlight birthdays occurring this month in Google Sheets using conditional formatting and custom formulas.
We have a list of birthdays in a Google Sheet and we want to know whose birthday is this month. Let's highlight all of the birthdays this month. We'll select our birthday column. Go to format , conditional formatting . Over here we'll change the format rules to custom formula , equals month, B1, and we'll wrap that up. Month around B1 is equal to month, and we'll put today inside of month. And you can see the, birthdays highlighted are this month, February. Click done. What is this Ampersand Doing in Google Sheets? 80 Years In 1 Spreadsheet How to List Every Day This Month in Google Sheets