Excel 2007 Conditional formatting with 2 conditions, one based off another column?

I'm using a table in Excel 2007. I'm trying to highlight cells in one column based off of its value and its status ...

Using SUM() in VBA?

If I have a set of cells in a worksheet that I want to add up, I can use the formula: =SUM(Sheet1!A1:A10) To do t...

How to create Excel file in asp.net?

I want to create Excel Sheet in asp.net. I have already done code for this and it is working fine in local system bu...

Setting Excel cell value based on another cell value using VBA?

I have the following spreadsheet. When ever there is an x in cell B I need to populate the d and e cells in the sam...

Excel VBA find maximum value in range on specific sheet?

I found that the following code is getting max value in range: Cells(Count, 4)=Application.WorksheetFunction.Max(Ra...

Excel - steepest and least steep lines?

Is there any way in Excel that I can get the steepest line and least steep line, given a linear graph? If it's not ...

How to change Named Range Scope?

When I create a named range through the Name Manager, I'm given the option of specifying Workbook or [worksheet name...

Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File?

I'm trying to create a macro which uses an ActiveX control button (click) to take a screenshot of my desktop screen ...

Array formula on Excel for Mac?

I need to call LINEST in Excel 2011 for Mac, I would say - this was a detective story. My laziness, my curiosity, al...

Find Column Header By Name And Select All Data Below Column Header (Excel-VBA)?

This is my first post... I'm attempting to create a macro to do the following: Search a spreadsheet column header...

How can VBA connect to MySQL database in Excel??

Dim oConn As ADODB.Connection Private Sub ConnectDB() Set oConn = New ADODB.Connection Dim str As String str = "DRIV...

Control Break out of Infinite Loop In 2010 (2013) Excel VBA?

If I write code creating an infinite loop, with my new Excel, the Ctrl + Break no longer works. Neither does the Esc...

Sigma or Summation function in Excel?

Given a value (in a cell), calculate a formula like this: Ʃ(3i+1) for i from 0 to the value specified in the cell....

How can I generate GUIDs in Excel??

I have an excel file with one order on each row, and I want each order to have a unique identifier, so there will be...

Generate N random numbers whose sum is a constant K - Excel?

How can I generate those numbers in Excel. I have to generate 8 random numbers whose sum is always 320. I need arou...