Macro Row coulour

josh - Sep 14, 2010 at 06:57 AM
 RayH - Sep 14, 2010 at 04:45 PM
I want to color the whole row ,the foremat would be like this
1.75% (h)
1.75% (g,p)
3.25% (a,h)
3.25% (a)
4.38% (a)
4.38% (a)

in the above column A represent %'s and Clmn.B to some ref id,if the ref id and % are same then color the whole row.above both 4.38% can be clubbed,but even therie is one more exemption ref id h need not be considered.that is we can club both 3.25%,but wheras we cannot club 1.75% as the first one doesnt contain ref idg and p.

Could you please help me out

1 response

Can you resubmit the question, its not very clear.
In your example, how is 1.75% the same as (h). Does (h) represent 1.75%? What do the other values in column b represent? What do you mean by 'clubbed'?
Sorry, its just too confusing.