Conditional Formatting based on Multiple Conditions.(With vba)

ootkhopdi

Board Regular
Joined
Sep 30, 2013
Messages
68
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...
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
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?
 
Upvote 0

Forum statistics

Threads
1,224,816
Messages
6,181,139
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top