Macro to fill cell based on another cell background color

Hi all,

I have one quick question or asking for a help actually.

I;m in the end of my macro and what I need is to fill cell based on backgroud color of other cell.

Example: In Sheet "Report" I have in cell "C9" cell with color index 3. What I need is to write in Sheet "Detailed Summary" to Cell "E4" number 1.
or if color index is 50, than write 3?


Is there anybody who could help? I would be able to modify macro but not sure, how to start to write it

Thanks
Andy

Hi,

I've modify that macro as per my needs and add one more argument to Else IF, however it doesn't work.

Example:

Please Login or Register  to view this content.

Last Elseif doesn't work. I'm not receiving any error, however I know, that in Cell "J9" I have color background "6". What works is only when I change code as below:

Please Login or Register  to view this content.

But as I have to replicate it 15 times, macro will be tool long. Do you know, where is an issue with ma macro?

thanks,
Andy

Hi all,

So I found out, that "OR" functions is doing my mess. Is there a way to fix it?
There should be only one condition met in ma macro, so I can't use function "AND".

Thank you