shading rows in excel
Condition1 =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 format as red
Condition2 =MOD(SUBTOTAL(3,$A1:$A$2),2)=1 format as green
Gord
On Sun, 9 Aug 2009 12:59:01 -0700, YESHWANT JOSHI
wrote:
BUT ALL THOSE ANSWERS GIVEN UNDER THIS HEAD COLOURS THE ENTIRE SHEET WITH ONE
COLOUR AND THE OTHER REMAINS WHITE. WHAT SHOULD I DO, IF I WANT TO FORMAT
WITH TWO SEPERATE COLOURS ?? (I TRIED THE SAME WITH ADDITION OF THE
CONDITION IN CONDITIONAL FORMATING AND THE SAME FORMULA, BUT IT DOEN NOT
WORK) WHY ??
"Gord Dibben" wrote:
If you won't be filtering the data use the other suggestions.
If you will be filtering use this formula in CFFormula
=MOD(SUBTOTAL(3,$A1:$A$2),2)=0
Gord Dibben MS Excel MVP
On Fri, 7 Aug 2009 11:47:01 -0700, juji
wrote:
How do I shade alternate rows in excel 2000
|