Color a cell depending on the result of another cell

[BastiDE]

Hi everyone,

I would like to color a cell in a sheet based on a result of another cell in onother sheet.
Here is source dataSheet1 excel draft.jpg
iI would like to color the ref from Sheet 1 in the column A if the ref in sheet 2 are the same ref and the value in the colum B is greater than 0
Could you please correct my code here below?

Please Login or Register  to view this content.

Thanks for your help

[vichopalacios]

Try this:

Please Login or Register  to view this content.

[BastiDE]

Hi
I have got this error

Subscript out of range (Error 9)

Any help?
Thanks

[Marc L]

Hi,

any information rather than a guessing challenge ?
Any attachment ?

[Marc L]

According to the initial post it can be directly achieved with an Excel conditional formatting rather than with any VBA procedure …

[vichopalacios]

Sorry for answering so late.

Where in the code do you find the error?
Did you check if the columns for Ref and Stock are correct?

I tested and did run OK for me