conditional formating-file attached

**afgi** · 11-02-2010, 06:49 AM

hi,

pls see the file attached

I need to make a macro that will paint the cells in one table, basing on conditional formating made in another table.

**teylyn** · 11-02-2010, 07:05 AM

hello,

can you please explain why the "after" sheet cells are highlighted? Are there any rules? If so, can you tell us in simple words?

cheers,

**afgi** · 11-02-2010, 07:37 AM

hi,

pink color is Conditional Foramting

grey is just a "copy" of the ceels from conditional formating, 3th column. I need to move results of the conditional formating to the top left corner table.

the bottom table, the one that has been formated in pink, is just a combine table made from 2 other worksheets (not included in the file enclosed - but it is not important for this theme) + the table from the top left corner. I just need to highlight the "ref&col" that has been used in two other workshhets.

**teylyn** · 11-08-2010, 05:12 AM

grey is just a "copy" of the ceels from conditional formating, 3th column

No, it's not. The values in column A have 6 digits. The values in F13:F22 have eight digits.

Please explain what you want to do. I can't look inside your head.

**afgi** · 11-09-2010, 06:00 AM

Dear Teylyn,

pls see the table attached

**teylyn** · 11-09-2010, 06:40 AM

I still don't understand your highlights. You'll need to explain in words.

**Marcol** · 11-09-2010, 07:15 AM

This can be done with conditional formatting.

Formula is:=

Please Login or Register  to view this content.

I have broken down the formula in this workbook to let you see how it works.
This can be deleted whenever it suits you.

Hope this helps

**afgi** · 11-09-2010, 08:43 AM

Dear Marcol,

you are very close. what I need now, is a macro that will automatically "paint" cells A2-B11. cells to be painted have to be selected basing on conditional formating (pink cells) from cells F13-F22.

pls work on worksheet "before". worksheet "after" is just to show you the final result I would like to achieve. many thanks

MANY THANKS FOR YOUR HELP

**Marcol** · 11-09-2010, 09:38 AM

Try this macro

Please Login or Register  to view this content.

I have coloured your table in your "before" sheet yellow to better demonstrate the result of the macro, run the macro on this sheet as a test.

How and when do you want to trigger the macro?