DanG
Registered User.
- Local time
- Today, 05:20
- Joined
- Nov 4, 2004
- Messages
- 477
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, but it won't find instances where is other values in the same cell.
I think it all comes down to how to use the astrisk within the code?
Any help would be appreciated!
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, but it won't find instances where is other values in the same cell.
I think it all comes down to how to use the astrisk within the code?
Code:
Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=IF(" & MySDA & "=[B]*69472*,1,0)"[/B]
Selection.FormatConditions(2).Interior.ColorIndex = 3
Any help would be appreciated!