Search results

Sorry for the confusion, never have been good at multitasking, I am working in Excel 2003 :) But, we will be moving to Office 2010 next year, so maybe there is hope...in the future. I don't think the limit is my problme, correct me if I am wrong. I do have 3 conditions. 1.) 50/50 column = if...

Thank you for your reply! I am using Access 2003, no ribbon. Code is needed because this is part of an add-in that multiple users have installed on their computer. Then they download the client list, clean it up (which this is a part of that process) and then they send it to the requester to...

Hi, The crappy code I made below is designed to condisionaly format on 2 columns, "Group Nmber" and "50/50 Category". Under "Group Number" I want all rows highlighted grey that are "or" contain "69472". And "50/50" I would like the entire row to be bold and italic if the cell contains either...

Hello, I'm just trying to get the concept (not on a project). In the code below, the first function defines a range and calls it "myrange". I then want to use that range in another fuction (2nd one down) to select it. I might want to do other things with this range in other functions too, not...

Sometimes your just have to go with the sloppy solution. I just made 2 conditions/versions out of it and it works fine now. I thnk in the end your solution was proper, I think there is a problem with the datatype. Thank you so much! Here is what I ended up doing...

It runs with no errors, but does not pick up any instance of 69472 at all.

Soooooo close! The code you gave me picks up on the 69472 when includded with other values in the cell but not 69472 when in the cell by itself. Weird though, after the code runs and I check the conditional format interface it looks like it produces the corrext formula to pick up everything...

I'm getting there... I did as you said (twice :)) and I think the only problem now is the use of my variable (MySDA) in the countif formula. I think it's now a matter of syntax? Here is what I have now, but am getting errors on running it... Formula1:="=COUNTIF(" & MySDA & "," * 69472 * " )>0"

Ok, base on the thought that a true/false could work, I got the formula COUNTIF($A1,'* 69472 *')>0 to work in the regular conditional formatting interface, but putting it into VBA errors. Below is the VBA change: Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=IF(" & MySDA &...

Thanks for the reply! That is what I was afraid of.

Hello, Below is a partial sample of conditional formatting code I have. Basically in the code I am looking for instances of "69472", but that value may not be the only number in a cell. It may show as: 2205,69472,123. I can get my code below to work only when 69472 is in the cell by itself...

That got me going in the right direction, thank you very much!

Thanks for the help anyway! That was psuedo code just to get the point accross and the hope that someone could take the psuedo code and make it into VBA :)

Thank you for the reply! Yes, row 1. So I can see where that would find the cell, then I would need to get the column letter into a variable. Then I need to use that variable in my if statment... Dim MyCol as string MyCol = the column letter from the cell that contains the results of the...

Hello, I have not been here for quite some time, but I just got stuck on this one and would love any help I can get... I have the following in some VBA and want to refine it a bit "=IF(OR($bf1=""At Risk"",$Bf1=""Default: Please Reassign""),1,0)" I would like to colunm reference "$Bf1" tends...

Got it! Basically what it does is looks for cells with "totals" in the text and when it finds it, it grabs the cells with the names from ond row above and copies them down. I also have it highlight the row to bold the totals. It's kind of neat cause it uses offset to look at the values above...

Hello, I have a sheet that I have created an outline on, each group has a total below them. It takes the 1st columns name and adds "totals" to it and then the columns that I get totals for get brought down. There are columns that I do not run totals on and they do not get brought down to the...

I have been a member here since 2004 and have received help and given help as well. This is the first time my plea for help has gone unanswered :( Thanks anyway.

Bump... any help would be appreciated:)

OK, I'm going to start over here and try to make it more simple... I have uploaded a new database for review and I think it will make it easier to relay what I need, please see attached. If you open the report, you will see I have everything except the group footers which I would like to...