I want to add in Pattern Fill, but it is not in the Add-In list. How do I get it?

Hi, Is it possible to replace a #N/A result with a particular text string? I know I could use Find/Replace, but I really don't want to lose the...

I have a roster of volunteers that I am trying to get into a calendar format. There are three rotations and several groups within each rotation (Greeters,...

Hi As part of a set of KPI's requested by a customer, I have to provide a weekly report demonstrating warehouse utilization during the week. The clients...

I have a spreadsheet with a number of similar rows and I want to be able to set the background colour of each row to cyan if the contents of cell...

I have two worksheets. I want to enter 2 numbers in two different cells on sheet 1 and then I want the result in a third cell to be the value of the...

give me farmula ligical

I am trying to do an HLOOKUP from one excel workbook to another but it is returning NA#. I know this can be done but not sure why its not working...

i have taken an existing macro that loops and am trying to tailor it to my needs. here is what i want to do 1. go to cell ai225 2. check the contents of...

I have the following code to replace two values in my sheet: Public Sub Replace_Y_With_Rate5() For Each cell In Selection cell.Value =...

Hi, i have this situation: database sheet: C D E F G den ref cod gr price mask ch09 0838 2 3.4 Work sheet: C D E ...

I have an xltm template used for invoicing. I have 2 combo boxes attached to different colunms of customer details with a linked cell in each of them. I have 2...

Hi, i need a macro to copy and add (i dont want to replace) the content of sheet 1 to sheet october. But i have in sheet 1, M1, a cell with october. I need...

Is it still possible in excel 2007 to create/add radio boxes, buttons etc to a workbook/spreadsheet. This functionality was available in 2003. It used to be...

How do I create the following to determine the value of Cell C? IF Cell A = blank then Cell C = "ZZZ" IF Cell A = non-blank and Cell B =...

I need to have A1 highlighted red if B1 has an x in it, and A1 highlighted green if C1 has an x in it. Can this be done?

I need a formula to do the following: If(c8-c9)*.04350000,75000,if(c8-c9)*.0125000,25000,if not then (c8-c9)*.01

For ease in reading a printed spreadsheet with many rows, I want to use alternate row shading. However, I also use the auto filter to show only rows that...

i'd would like to install PHstat how can i find this application in excel someone help me please . thank

how do i get so that one column has one decimal place and another column has two decinmal places?