User Profile
Ahmed_Ezzedin
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
- 1.3KViews0likes1Comment
Mail merge record number
I have created a spreadsheet to enter and track data. I'm using sheet1 to enter various data. In sheet2 I'm using a FILTER function to create a list based on values in column L in sheet1. The data in the list in sheet2 is used to create a mail merge in word. my question is, is there a way to have excel automatically count / assign numbers to entries so that I can know what would be the record number for this entry in Word?Solved1.4KViews0likes3CommentsConditional Formatting based on a range of values
Hi everyone, I'm trying to highlight rows in a table based on values of cells in another table in another worksheet (sheet1). Both tables contain zip codes, however, the table in sheet1 divides the zip codes by office. I want to highlight zip codes of each office with a different color. this the table I want to apply the conditional formatting to, values starts in A4 and B4 This the table in Sheet1 where zip codes are divided by office. Data starts in A2, B2, C2, and D2 Thanks in advance for all you comments and assistance.1.9KViews0likes5CommentsConditional formatting
Hi everyone, I need to create a conditional formatting to cells A21 to A39. I need them to change colors when certain values are entered. I named those values Mylist, but the problem is that these values (list) is on a different worksheet (sheet2). I tried using the=SUM(COUNTIFformula but I can't get it to work. Can anyone help me please. Thanks, Ahmed1.1KViews0likes4Comments
Recent Blog Articles
No content to show