Recent content by EcoWill

That works. Thanks.

Hi all - I am concatenating three cells in Excel, (two text, and last one a date) and the concatenation works but is converting the date value into a number. How do we keep it as a date format? Thanks

Hey folks- of course Skip's 'paste formula' option is the way to go, and I knew that. Forgot. Duh. I don't get the option box that xlhelp suggested either, but will try that when I get home from my vacation or maybe sooner when I get to where I am going. (The Rockies). Thanks again!

Hi all - when you drag down the fill handle to auto-fill a formula down a column, it also drags out the formatting of the cells in those columns and you have to go back and re-do them which can be a pain. Is there a way to fill only NUMBERS and not cell formatting too? Thanks mucho.

Actually, no. It is in Review > Protect Sheet dialog box. Found it, and it works. If you go File > Save As there is no Tools button in this version.

Hi - I want to lock workbooks and password protect them, but it ain't working. This is Excel 2010. I click Review > Protect Workbook> then check Structure and Windows, then put in a password, and after i do that, anyone who wants can still go in there and make any changes that they feel like. It...

Ok thanks for that, but I do not see where I am choosing a color. If I want yellow, where is that in the formula? How about Green? Etc. And then there is the other issue - how then do i do a range to say, from 8-15 days, then yellow? Is it possible?

That is fine - the coworker who wants this answer wants red for next week (7 days or less) yellow for 8-14 days blue for 15-30 days. The colors will be in a separate cell than the date. Make sense? I hope

Hi T.T. - I know this is a conditional formatting plus date function question, but just not sure how to combine the two. I will use the =now() function as a reference. If a future date in a cell that is 'written in' (like September 15, 2011) is within 1 week i want the cell color to be red or...

Ah yes - the helper column of numbers. Jeez. I have done that often in the past, but it has been a while. Totally forgot. Anyway - this was all good advice, and now I have a plan going forward. Thanks and hope you are having a nice holiday weekend.

If it were any kind of science I would be better at it. I am a biochemist doing Excel!

So then what I did was to just copy and paste just the values to another new worksheet and left the formatting behind. Internally it was remembering the blanks. Anyway, I have moved on with the workaround and I appreciate the help.

I have no idea what you are talking about. When I selected the filter and checked blanks only, practically everything on the page disappeared. I am not an Excel expert. You are. Not me. And when this government job ends, I will retire and travel the country in my new expensive RV. I am only...

You are right. Not only did I not follow your instructions, but I also did not understand them. When I turned the filter on, I unchecked []Blanks and the blank rows disappeared. So far so good. Now what am i supposed to right-click on? What blank rows? They have vanished.

When i clear the filter, the blanks reappear!