Well I have attached a sample file, that need manipulate to accomplish my needs.
I have in sheet1 2 "ranges" :
range1 :A6:L25 (table1)
range2 :N6:Y25 (table2)
I need away (vba accepted), that colors the rows like this:
if in A8:A11 range there is a cell.value that matchs in N8:N11 go and color N8:N11 and 08:y8 relatively.
in sample I have:
N8.value=A8.value + A10.value result:
O8:Y8 colored same as B8:L8 +B10:L10
also if :
C24.value=P24.value color both green
If not Flash/blink Both
same as C25.value=P25