I'm trying to write a formula for my spreadsheet that has the
following logic:
If current value (column G) is greater than value located in (column
D), then change the font color to green. If not greater, then change

I am trying to create an if statement that will count a cell it the font is a
particular color, I just don't know the syntax of the logical expression
ex
if(A5.font = "blue"), 1, "  ")

My VBA is running on a PerformancePoint Excel Add-In Form.  According to the
PPS Help, I may create the subroutines that are based on the
BeforeAssignmentAction event.  I cannot seem to get this action to work.
In ThisWorkbook:

Could someone offer a quick assist on how to capture the result of the
replace function in a variable rather than in a cell...
***********************************************************************************
Dim Alphabet As Variant

I USE MS OFFICE 2003 AND I JUST DOWNLOADED AND INSTALLED MS VB 2008 EXPRESS
EDITION. NOW WHEN I START EXCEL EVERYTIME IT IS STILL LOOKING FOR VB 2005
EXPRESS EDITION AND ASKS ME FOR VBSETUP.MSI FILE WHICH IS NOT THERE IN MY
COMPUTER SINCE I HAVE UNINSTALLED VB 2005 EXPRESS ...

I have a bunch of cells that have measurments in them formatted like this 3'-
0".  I would like to change these to 3/0 but when i do a find and replace
(even after setting the format to text for these cells) it turns them into a
date.  is there a way to do a find and replace but ...

I use the "Do Until...Loop" in forms subroutine to insert a row in worksheet
at specified location. How do I get the row number of the new row?
Private Sub cmdInsertRow_Click()
Dim ws As Worksheet

I have these two macros in VBA and they will not work.  If I put them in
sepratly they will work but when I put them in together they will not.  Can
you help me fix this so I can get them both to work???  Thanks in advance for
your time!

OK - I'm using the =na() trick to keep missing values from plotting a
zero value.  Now, the only issue I can’t resolve is the data labels.
Excel is labeling the missing (empty) points with "#N/A"
This is not the behavior I desire.  I'd like Excel to "not label"

Is there a way to have a formula and some text after the formula in the same
cell?

Not sure if this Q should be in programming or Worksheets functions.  There
are 2 systems, (for double checking purposes) inputting data.  The master
system will save the file as master.xls.   The 2nd system will save their
file as compare.xls. It will then be compared  to the ...

I have a column of data that is a list of dates and times as a schedule.
Each date listed may have several times underneath it (i.e., 4/16/08 could
have 9:00AM, 10AM, 11AM underneath it). I would like to be able to
automatically erase the times and replace them with the date they ...

I am trying to get cell (S5) to auto fill when you enter the weight of the
vehicle in cell (W5).  If the vehicle weights 50,000 lbs or more it needs to
be classified as a "HEAVY TRUCK".  If the weight is less than 50,000 it needs
to be classified as a "LT DUTY TRUCK".  If there ...

Hey Guys,
I am stuck on a problem and would really appreciate some help with it.
I heard this is a good place to look for help. =)
I have sequential dates in Cells C3:IV3, with correlating data for

I have 2 sheets in a workbook that import data from an access on refresh. One
works and the other one doesn't. I keep getting "disk error". I would like to
delete the query and start over. How do I do this?