Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating macro code in Excel
Hi There,
Can anyone give me some tips or idea on how to create a macro that would change the color of my data in a table. Please see my excel sample table below: look up table: 10 20 30 40 50 60 Col1 Col2 Col3 Col4 Col5 Col6 Row1 10 11 12 13 14 15 Row2 16 17 18 19 20 21 .. .. .. Row10 35 36 37 38 39 40 Here how it goes, for example in the look up table I have 10 and when I find 10 in Row1/Col1 I would like to change it to color RED, Then, If I have 20 in lookup table and I find it from Row2/Col5 I would change it to color BLUE, and so on. Can anybody have an idea on this? Appreciate your help. thanks Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can anyone help with the code for creating a aut print macro... | Excel Discussion (Misc queries) | |||
Creating a code for a macro | Excel Discussion (Misc queries) | |||
Creating a macro in excel | Excel Discussion (Misc queries) | |||
Creating Macro or Code Help? | Excel Worksheet Functions | |||
Creating a macro in excel | Excel Worksheet Functions |