Chip code problem - conditional formatting colors GetStrippedValue

[Barney Fife]

Very sorry if this is duped - Google Usenet posting is not quite prime
time, and gave several "page not founds" on submission; then a good
"submitted" page, but that was many hours ago and AFAIK never made it.

re: http://www.cpearson.com/excel/CFColors.htm

I'm having problems with the function GetStrippedValue at the bottom
of that page. With highest respect for Chip there seems to be a bogus
line
Temp = Mid(CF, 3, Len(CF) - 3).

Perhaps it should be
Temp = Mid(Temp,2)
or
Temp=Mid(CF,1+InStr(1,CF,"=",vbTextCompare)3,Len(CF)-InStr(1,CF,"=",vbTextCompare))

but my cylinders aren't all quite firing as to why GetStrippedValue
thinks there might be equal signs where it is looking for them. I'll
defer to the experts on that.

P.S. Several email reports to Chip on this apparently bit-bucketed

 

[Dave R.]

Barney- try posting over at
www.excelforum.com or at the microsoft support portal.

the posts will appear much faster on the newsgroup.