vba - Highlighting cells in excel based on complex conditions -

i trying nested conditioned formatting.

here example explain: have 3 tables, each of them highlighted (green, or red) based on condition. in each table, red highlighting specific rows "lasso", while green highlighting row "stepwise".

• now, highlight in blue column names (val, eq, eff, size, ..) if cells in corresponding columns highlighted in each table in both green , red.

example: mom highlighted in 3 tables, , highlighted in every table in both green , red (i.e. both lasso , stepwise). in case, want highlight the cells f2,f9 , f16 in blue.

• then, highlight in purple column names (val, eq, eff, size, ..) if cells in corresponding columns highlighted in each table in green or red.

example: ump highlighted in tables, not in green , red in every table (as see, in table 1, highlighted in red, not green). in case, want highlight cells k2,k9 , k16 in blue.

this looking for:

i apologize if explanation bit confusing. ready give further details/examples if needed.

thank you,

something along following lines should suit:

applied row1 , copied rows 9 , 16 format painter.

the actual components within =and depend upon trigger points existing green , red formatting.

edit: image "applied row1":

it never idea apply conditional formatting more cells necessary (say ~ required + reasonable margin future growth) because such formats highly volatile.