User Profile
SeanHaggerty
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Widening the drop down list without changing the cell size?
In the dropdown list that I created for my worksheet, I have several items that are wider than the dropdown window allows me to see. Is there a way to adjust the width of the dropdown, without adjusting the size of the cell, so I can see the full line? I don't really want to have to extend the cell to 2-3x the size to be able to read the line, and can't really shorten the names for the tracking purposes that the other sheets are referencing, but blind guessing which item is obviously going to be a pain as well.Solved5.8KViews0likes2CommentsConditional formatting formula using 2 criteria, for 2 different limits
I am trying to create a conditional formatting highlight formula that will highlight the cell if the date in C5 is more than 5 years and P5 has a value of more than 15, or if the date in C5 is less than 5 years and P5 is more than 10. I have gotten to the point of being able to highlight the first part using this formula, but can't figure out how to introduce the second aspect and not get an error. =AND(TODAY()-$C$5>=(5*365),$P$5>15) I have played around with trying to make it work with an OR function, but keep getting an error. =AND(OR(TODAY()-C5>=(5*365), P5>15),(TODAY()-C5<=(5*365), P5>10)) Any help on where I am going wrong is really appreciated!Solved748Views0likes3CommentsAveraging the sum of a specific cell across multiple sheets
Hello, I am trying to average a specific cell across a range of sheets where they have all been named with text (Not sure it matters?). The fixed cell that I am trying to average does have a formula in it to provide the number that I want to average (Again not sure if this will cause an issue?) The formula that I am using is =AVERAGE('SHEET NAME 1':'SHEET NAME 2'AC25!) but this is clearly the wrong way to go about it, as I keep getting a #NAME? error. I took a look at some of the suggested/previous posts that were similar, but haven't been able to get any of them to work properly.Solved3KViews0likes8Comments
Groups
Recent Blog Articles
No content to show