Re: shading rows in excel
- From: YESHWANT JOSHI <YESHWANTJOSHI@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 11 Aug 2009 08:55:05 -0700
it seems that i had not been clear to u sir
what is want is
row no. 1 - one colour
row no. 2 - another colour
row no. 3 - one colour (same as row no. 1)
row no. 4 - another colour (same as row no. 2)
............ so on
"Gord Dibben" wrote:
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
<YESHWANTJOSHI@xxxxxxxxxxxxxxxxxxxxxxxxx> 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 CF>Formula
=MOD(SUBTOTAL(3,$A1:$A$2),2)=0
Gord Dibben MS Excel MVP
On Fri, 7 Aug 2009 11:47:01 -0700, juji <juji@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
How do I shade alternate rows in excel 2000
- Follow-Ups:
- Re: shading rows in excel
- From: Gord Dibben
- Re: shading rows in excel
- References:
- shading rows in excel
- From: juji
- Re: shading rows in excel
- From: Gord Dibben
- Re: shading rows in excel
- From: YESHWANT JOSHI
- Re: shading rows in excel
- From: Gord Dibben
- shading rows in excel
- Prev by Date: Re: Excel crashes when copying to Word??
- Next by Date: Sorting/Working across multiple worksheets
- Previous by thread: Re: shading rows in excel
- Next by thread: Re: shading rows in excel
- Index(es):
Relevant Pages
|
