Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello,
i am sorry to bother you again. i need something similar to this: instead of writing true or false in a cell, the color(background and/or -it doesnt matter) of a cell/string should be changed if the comparison matches. here is the code: Code:
For i = 1 To 7 lzi = lzi & i For j = ez To lzi MyString = Cells(j, i).Value Select Case Len(MyString) Case Is = 0 Exit For Case Else MyString = Left(MyString, InStr(MyString, ".")) MyString = Replace(MyString, ".", "") End Select '-- Should be altered to something like MyString.Font.Color: MyString = Not IsError(Application.Match( _ Cells(j, i).Value), Columns("S:S"), 0) Next j Next i thank you in advance. regards p.s. sorry, for my bad english. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup found two similar values | Excel Discussion (Misc queries) | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
Vlookup on a worksheet with similar values | Excel Worksheet Functions | |||
Counting cells, similar values | Excel Worksheet Functions | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming |