Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

conditional formatting question

Status
Not open for further replies.
Apr 15, 2003
41
US
i have figured out how to highlight everyother or every second row using the MOD formula, is there a way to write a formula so that i can highlight three rows, leave three rows, highlight three, leave three, etc
 
Hi,

=INT((row()-1)/3)

Skip,

[glasses] [red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!
[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top