Pages

Search

Excel Help Forum - Excel General: [SOLVED] Looking to calculate months

Feed2Mail notification - new post on Excel Help Forum - Excel General
[SOLVED] Looking to calculate months
Hello, I have a simple spreadsheet that will calculate rental payments based on any given month for 1 month. I'm looking for help that will calculate based on 2 or more payments. I'm using this to calculate 1 month - =IF(C2="","",(DATE(YEAR(C2),MONTH(C2)+1,0))) C2 would equal the 1st day of...

Office IT Pro General Discussions Forum: Power point tablet bug

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Power point tablet bug
When I use the pen in a powerpoint presentation it freezes up.

Excel Help Forum - Excel Charting & Pivots: Multiple Criteria to Display on a Chart

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Multiple Criteria to Display on a Chart
Hello I currently want to display multiple people's stats on a single chart. Although, I would like it so that when i were to click on a single name it showed just that person's stats, but when selecting multiple names it would show their individuals stats on the same chart. I can therefore...

Excel Help Forum - Excel Programming / VBA / Macros: Worksheet change event suddenly not working

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Worksheet change event suddenly not working
Hi there I am stumped. I had this code that was working fine up to last night when I tried to change parts of it to make if more effecient. However I couldn't make that part work, so changed the code back the what it was originally (recopied from an earlier version I'd saved) but now it will...

Excel Help Forum - Excel General: Navigate between sheets without Page Down

Feed2Mail notification - new post on Excel Help Forum - Excel General
Navigate between sheets without Page Down
I'm running Microsoft Excel for Mac 2011 on my Macbook Air and every resource I've searched mentions the Control+PAGEUP/DOWN keyboard shortcut to navigate between sheets. As there is no Page Up/Down keys on the Air's keyboard, I was wondering if there was any way to change the keyboard shortcuts in...

Excel IT Pro Discussions Forum: Conditional formatting using named cell in Excel 2010

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Conditional formatting using named cell in Excel 2010

Greetings,

I want to use a named cell in my Conditional Formatting rule. Let's call it "red_target".

I want to be able to tell the rule, "If cell value is greater than red_target, turn red."

When I type "=red_target" or "red_target" in the Value: field, it thinks I literally mean the string "red_target."

When I use the picker to navigate to that specific cell, it doesn't fill in the name. It uses the R1C1 absolute reference.

Any ideas on using named cells in Conditional Formatting rules?

Thanks,
Rachel

Excel Help Forum - Excel Programming / VBA / Macros: Define range of formula in VBA based in first blank cell

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Define range of formula in VBA based in first blank cell
Hello everybody, I'm not an expert in VBA, and I need help for the following problem: I have a column with a lot of values that must be summed. The number of filled rows for this column will vary. There is a blank row on the top of the column. So far I have this: Code:
Subscribe to: Posts (Atom)