UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Closed TopicStart new topic
> alternate row colours in excel worksheet    
 
   
argeedblu
post May 16 2006, 06:20 AM
Post#1


UA Forum + Wiki Administrator
Posts: 14,057
Joined: 26-September 02
From: Sudbury, Ontario, Canada


My apologies if someone has already posted this tip.
You can create a worksheet with alternating coloured rows (striped) with conditional formatting.
First, select the range that you want striped (or the whole sheet).
Next, go to Format/Conditional formatting. In the dropdown where it say value is, select "formula is"
In the textbox on the right type the expression "= mod(row(),2)=0" (without the quotes, of course.
Finally, set the format that will apply to even rows.
You can vary the frequency of the stripe by using a value other than 2 in the mod function. If you want odd rows rather than even rows to be formatted, change the 0 to 1.
Glenn
Go to the top of the page
 
KingMartin
post May 16 2006, 03:04 PM
Post#2


Retired Moderator
Posts: 10,959
Joined: 9-October 03
From: Prague,CZ / Kiev,UA


Why not moving this into Excel FAQs Glenn?
Very useful trick...
I would add - just for fun - a chequered flag:
=MOD(ROW()+COLUMN(),2)=0
Regards,
frown.gif
Martin
Go to the top of the page
 
argeedblu
post May 16 2006, 03:08 PM
Post#3


UA Forum + Wiki Administrator
Posts: 14,057
Joined: 26-September 02
From: Sudbury, Ontario, Canada


Martin,
hat's a neat trick, too. Thanks. I will move the thread to excel faqa's and close it.
Glenn
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    13th December 2017 - 02:10 AM