B
Barney Fife
Re http://www.cpearson.com/excel/CFColors.htm
The function at the bottom of his page is GetStrippedValue. I have
had problems there. With all gracious respect to the Mighty C, the
statement
Temp = Mid(CF, 3, Len(CF) - 3)
seems bogus. E.g., what if the condition arg was "=IV6" as opposed to
"=I6" (all quotation marks are my own, not the conditional format's),
for a cell with [the sole] conditional "not equal to"
I've contemplated possible replacements:
Temp = Mid(CF, 2)
Temp = Mid(CF,1+InStr(1,CF,"=",vbTextCompare),Len(CF)-InStr(1,CF,"=",vbTextCompare))
I'm fuzzy on the drift of GetStrippedValue anyway so I'm open to
elucidation.
Emails reporting this don't seem to be getting there. Are your ears
on, Chip?!
The function at the bottom of his page is GetStrippedValue. I have
had problems there. With all gracious respect to the Mighty C, the
statement
Temp = Mid(CF, 3, Len(CF) - 3)
seems bogus. E.g., what if the condition arg was "=IV6" as opposed to
"=I6" (all quotation marks are my own, not the conditional format's),
for a cell with [the sole] conditional "not equal to"
I've contemplated possible replacements:
Temp = Mid(CF, 2)
Temp = Mid(CF,1+InStr(1,CF,"=",vbTextCompare),Len(CF)-InStr(1,CF,"=",vbTextCompare))
I'm fuzzy on the drift of GetStrippedValue anyway so I'm open to
elucidation.
Emails reporting this don't seem to be getting there. Are your ears
on, Chip?!