[RESOLVED] [MS EXCEL 2010] Conditional formatting based on two Criteria’s
Dear All,
I wated to change the format of the cells when the following two criterias are met 1) Cell value = 0.0001 and 2) Any of the following Cells (K17,M17,O17,Q17,T17,V17,X17,Z17,AC17,AE17,AG17,AI17,AL17,AN17,AP17,AR17,AU17,AW17,AY17,BA17) value is greater than 0 then the text colour should change to red.
Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s
What do you want the "trigger" to be? For example, when a cells value changes, check the criteria? Or run a macro and check all cells? Or something else?
Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s
I have a text in column BD that should change to red only if the above mentioned two conditions are met. I have also attached a sample worksheet for your reference. Please let me know if you need any further information
Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s
basically the blank cells in Column J are having 0.001 values. So for that entire row if you enter any value which is greater than 0, then column BD text should change to RED
Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s
Ok, but you still haven't answered the question of what you want to be the trigger. What action do you want to initiate this check? A button click? Any change to the sheet? Other?
Re: [MS EXCEL 2010] Conditional formatting based on two Criteria’s
This looks great. But how do I copy to the below rows? If I copy the conditional formatting, then the formula values are not changing. For example if I want to copy the formula till 1000 rows how do I do that? because formula and conditional formatting is copying, but still it is showing a2>0,b2>0 etc. it should automatically change to a3, a4, a5 etc