Re: Conditional Formating - Different row color also when using fi
- From: "Max" <demechanik@xxxxxxxxx>
- Date: Thu, 4 Jan 2007 06:56:53 +0800
Good to hear that ! Thanks for posting your findings.
Yes, like in life itself, those dollar signs can really make a crucial
difference <g>
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"KC Rippstein hotmail com>" <kcrippstein<atdot> wrote in message
news:AD581BB5-6841-437C-8505-05766869F9BB@xxxxxxxxxxxxxxxx
I just figured it out. Simply put a dollar sign in front of the second A.
Instead of
=MOD(SUBTOTAL(3,$A$1:A1),2)=0
use
=MOD(SUBTOTAL(3,$A$1:$A1),2)=0
All we really care about is the counta from column A, so that can stay
fixed.
YES!!
- KC Rippstein
.
- References:
- Re: Conditional Formating - Different row color also when using fi
- From: KC Rippstein hotmail com
- Re: Conditional Formating - Different row color also when using fi
- Prev by Date: Re: Referencing Row Range in another cell
- Next by Date: Re: International Yes or No
- Previous by thread: Re: Conditional Formating - Different row color also when using fi
- Next by thread: Re: Referencing Row Range in another cell
- Index(es):
Relevant Pages
|
