conditional formatting with WILDCARD

[MR3]

is it possible to format a row with the condition NAME_* where name is always the same prefix?
thus if a row contains this particular prefix it will flood fill the entire cell

 

[MR3]

i didn't realize you posted.. but this is what i came up with and its not working properly.

Sub ApplyCF()
Dim var1 As Integer
Dim var2 As String
var2 = InputBox("Enter a String", "Input")
var1 = Len(var2)
With Columns("C")
.Select '2007 & earlier
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, _
Formula1:="=LEFT(C1,var1)=""var2"""
.FormatConditions(1).Interior.ColorIndex = 35
MsgBox "Value added to total."

End With
End Sub

I am going to try your code now Peter, thanks for posting.

 

[Peter_SSs]

i didn't realize you posted.. but this is what i came up with and its not working properly.

NO, you haven't built up the formula string correctly. You could do it like this

.FormatConditions.Add Type:=xlExpression, _
    Formula1:="=LEFT(C1," & var1 & ")=""" & var2 & """"

Note though that if you do not put a check in about var1 being greater than 0, your whole column will be coloured if the user does any of these things with the Input Box :
- Closes it with the X at the top right, or
- Clicks OK without entering anything in the text box, or
- Clicks Cancel

Also note that when posting code, please have your code indented and keep that indentation by using code tags as I have done here, or use the VBHTML Maker as I did with my earlier code. It is much harder to read and debug unindented code and many potential helpers will jsut by-pass your thread if your code is not indented. Further info in my signature block.

 

[MR3]

NO, you haven't built up the formula string correctly. You could do it like this

.FormatConditions.Add Type:=xlExpression, _
    Formula1:="=LEFT(C1," & var1 & ")=""" & var2 & """"

Note though that if you do not put a check in about var1 being greater than 0, your whole column will be coloured if the user does any of these things with the Input Box :
- Closes it with the X at the top right, or
- Clicks OK without entering anything in the text box, or
- Clicks Cancel

Also note that when posting code, please have your code indented and keep that indentation by using code tags as I have done here, or use the VBHTML Maker as I did with my earlier code. It is much harder to read and debug unindented code and many potential helpers will jsut by-pass your thread if your code is not indented. Further info in my signature block.

sorry about not posting the VBHTML. i will be sure to post code correctly from now on.

on my input window is there a way to input 2 different values in the same box or do i have to declare another MSG box?

 

[Peter_SSs]

on my input window is there a way to input 2 different values in the same box or do i have to declare another MSG box?

I'm not sure what you want to with the two inputs but for collecting them, a few choices come to mind:

1. Create a Userform with two Text Boxes to collect the information.

2. Have an Input Box collect the first value then another Input Box to collect the second value.

3. Use a single Input Box and enter the two values separated by some special character (eg "/")

 

[MR3]

These are really great options Peter.

How about the User Input Box, where they can enter data and use a check box in that same box to choose what other data is to be.

So keeping it similar but just adding a choice AM or PM and then there is a check box next to that which refers to a specific column.

 

[Peter_SSs]

How about the User Input Box, where they can enter data and use a check box in that same box ...

An Input Box as we used in the earler code in this thread is a simple structure that allows a single input. If you want anything more complecated than that, you will need to use a UserForm. UserForms are not a real strength of mine, but here is one place that has some resources you might find helpful.
http://www.contextures.com/xlUserForm01.html