Hi, Thanks for the response.

Actually I was hoping to do it with a macro if possible.

I have a long column 'L' with more than 35000+ rows.
About 20% of the entire column (~7000) fields/cells of L
are formatted violet (the interior color of the cell is violet)
The rest of the cells are white/nonformatted in color

However the color/noncolor is RANDOM and does not follow a pattern.

I would like to have a macro that tests if that cell is violet first,
then if yes, let it process the cell.

Here is what I am trying to do but the code does not work/compile
correctly

Option Explicit

SUB CHECKCOLOREXISTSTHENGETGOOGLEURL()


FOR EACH CELL IN COLUMN L FROM L1 TO
L31886


IF CELL.INTERIOR.COLORINDEX = 13 THEN
CELL.FORMULA =
=HYPERLINK(\"HTTP://WWW.GOOGLE.COM/SEARCH?HL=EN&Q=\" & C1 & \"+\" & H1
& \"&BTNG=GOOGLE+SEARCH\")

END IF
NEXT CELL






END SUB

thanks


--
bxc2739
------------------------------------------------------------------------
bxc2739's Profile: http://www.excelforum.com/member.php...o&userid=32538
View this thread: http://www.excelforum.com/showthread...hreadid=535503