•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Trying to create a spreadsheet where cells are highlighted if name of month typed matches current month
Our take
Creating a spreadsheet to track employee birthdays and anniversaries by month can enhance your office's planning and celebration efforts. To achieve this, you can use conditional formatting to highlight the rows where the month matches the current month. By inputting just the names of the months (like March or April), you can set up a visual cue, turning matching cells green. This approach allows your office manager to quickly identify upcoming celebrations, simplifying the tracking process without needing full dates.
I'm trying to create a spreadsheet for our office manager to help keep track of birthday months and anniversary months of employees.
What I'm trying to do is create a row in which employee birthday months are typed (March, April, etc) - and not exact full dates.
I want to create conditional formatting where all of the text values that match the current month are green, so she can scroll through each month and make a quick list of anyone with a birthday/anniversary that month.
We will not have full birth or anniversary dates, just the name of the month.
I have tried all sorts of formulas from google searches, to no avail.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
- Conditional Formating to highlight different dates on a spreadsheet.Hi there, I need assistance with creating a formula to highlight dates that are 3 - 6 months hold and dates that are +6months from the date I open the spreadsheet. Example, this spreadsheet was created today, but if I were to open the spreadsheet on 3 weeks, the highlighted dates change according to that days dates if applicable to the rule. The data I'm trying to do this for is A1:J565. Row 1 are column titles if that makes a difference for the rule. The date colum is I. I appreciate any help I can get. submitted by /u/Salty-Departure7245 [link] [comments]
- Monthly tracking workbook I use to track employee sales metrics; Trying to find a way to make the process less labour intensiveTruly having a hard to describing my issue effectively but hoping someone can help. First time posting here and I'm by no means an expert with excel, so please be kind! I have a monthly workbook where I track each employees revenue and other metrics. Every 2 weeks for payroll, I provide a print out of these numbers, and the payroll sheet pulls data from multiple sheets in the workbook. For example, every workbook has a separate sheet for each day of the month, titled "1" through "31". I have pay period sheets, so I'll use one titled "04.02.26 - 04.15.26". Then I'll have the data for each employee pulled from multiple sheets. For example, I use the formula =SUM('2:15'!E3) to pull the sales data from each day of that period for the specific employee. This works quite well. However, when I create a new month's spreadsheet, I have to manually alter this formula for each employee and for each data point (more than just revenue, at least 6 different data points for 7 employees). Is there a way to automate this? For example, a cell or two where I'm able to enter the date range and all of the formulas update to that date range for the corresponding pages? I'm sorry of this post is confusing. Truly it's confusing even typing it! submitted by /u/Ok_Smile9222 [link] [comments]
- Sum formula for calculating month occurrences from dates works for everything except for January.I am attempting to automate the calculations of how often each month is recorded in another tab. The formula is working for all the other months, but as I am using this template to calculate values as I enter them, I arbitrarily set the limit to 2000, allowing me not to have to think about changing the formula as I enter new information. Unfortunately, it seems that the blank cells are being coded as "1" https://preview.redd.it/7zte9xn701vg1.png?width=972&format=png&auto=webp&s=ba131bec322f84ce55fa9fdbc35cedfcbeb12d9f I have tried going through the formula and found that all the blank cells are coding themselves as "true" only for the month of January (1). I attempted to add =IF(SHEET2!A3:A2000 = " ", 0, ... to the beginning of the formula, but it just gave me a spill error. I might be getting confused between excel vs. Google Sheets formulas. Thank you! submitted by /u/mentallylost14 [link] [comments]