Conditional Formatting based on Multiple Conditions.(With vba)

[ootkhopdi]

Hi. All

i am using excel 2016

i have a worksheet with 100 columns and 5000 rows..
in my data a column heading "Balance in repeating after 4 columns .like Column e, column J........

i want to create a rule for conditional formatting which applies only in column which having Balance, Means Column e, Column j...(and others.)


when balance is less than 0, row colour is red
when balance is greater than 0, row colour is green
when balance is 0, row colour is yellow

Column heading , Balance, in row 4..

any one help me..


vba also accepted...

thanks in advance...

 

[Joe4]

OK, if I understand you correctly, you have multiple columns with a heading of "Balance", i.e. columns E, J, etc. (by the way, are headings always in row 1)?
So, what if in a particular row (say, row 4), the "Balance" in column E is less than 0, but then "Balance" in column "J" is greater than 0?
Then what color do we want to make row 4? Red or green?