Inserting comment depending on the Conditional formatting

L

Little Master

Hi

Is it possible to insert comment depending on the conditiona
formatting.I mean if the color of the cell is blue the comment shown i
" A " & if the color of the cell is green the comment shown is " B "
similarly if the color of the cell is black the comment shown is " C
. ( The color names which i had writted here r examples i dont know th
real names of the colors which i have given in my spreadsheet)
 
L

Little Master

Thanks Dominicb, thanks alot for your reply.But unfortunately i don
have any programming knowledge.Pls tell me wat to do with this code
 
D

dominicb

Hi Little Master

From Excel make sure that only the worksheet you want to apply this
code to is open (say mywork.xls). Press alt + F11 and from the project
box make sure mywork.xls is selected. Go to Insert > Module and a blank
window should open taking up most of the visible area. Copy the code
into this area and then close the window. To run the macro go to Tools
Macro > Macros, select Macro1 from the list and run (or click on the
Click to expand...
options button to set up a shortcut to run the routine).

Just remember that as it stands at the moment the code only checks for
ColorIndex 50 (which is dark green), and if you want to check for other
colours you will need to know the colour index. On my system (XL2000) I
can press alt + F11 to open the macro editor, press F1 for help and
under the help index tab type colorindex, and a help page comes up that
shows all colours in the DEFAULT colour palette and their associated
numbers. Hope that gets you started for now...

HTH

DominicB
 
D

dominicb

Hi Little Master

If you want to send me a private message with your e-mail address I'll
send you an example file and try and help you from there.

DominicB
 
H

hmmm

hI!

i'm new in macros too and i'm so happy to have tried my 1st MACRO using
the guide u've given!

i wonder if there is any good web tutorial on macro u can recommend for
newbies like me?

thanx so much!
 
Top