Home |
Search |
Today's Posts |
#1
|
|||
|
|||
coloring every other row in a range
I would like to add a color to every other row in a specified row/column
range. In addition if a row is inserted I would like it to continue the color pattern of every other row being colored. |
#2
|
|||
|
|||
Assuming that your range is B5:E10...
1) Select your range 2) Format Conditional Formatting Formula Is 3) Enter the following formula: =MOD(ROW(B5)-ROW($B$5)+0,2)=0 4) Choose your formatting 5) Click Ok This will highlight every other row starting with the first one. If you want to highlight every other row starting with the second one, change the +0 part of the formula to +1. Hope this helps! In article , Tat wrote: I would like to add a color to every other row in a specified row/column range. In addition if a row is inserted I would like it to continue the color pattern of every other row being colored. |
#3
|
|||
|
|||
Thank you . It works wonderfully!
"Domenic" wrote: Assuming that your range is B5:E10... 1) Select your range 2) Format Conditional Formatting Formula Is 3) Enter the following formula: =MOD(ROW(B5)-ROW($B$5)+0,2)=0 4) Choose your formatting 5) Click Ok This will highlight every other row starting with the first one. If you want to highlight every other row starting with the second one, change the +0 part of the formula to +1. Hope this helps! In article , Tat wrote: I would like to add a color to every other row in a specified row/column range. In addition if a row is inserted I would like it to continue the color pattern of every other row being colored. |
#4
|
|||
|
|||
This is one of many standard features of ASAP Utilities, available free at
www.ASAP-utilities.com Vaya con Dios, Chuck, CABGx3 "Tat" wrote in message ... I would like to add a color to every other row in a specified row/column range. In addition if a row is inserted I would like it to continue the color pattern of every other row being colored. |
#5
|
|||
|
|||
Thanks for that info.
"CLR" wrote: This is one of many standard features of ASAP Utilities, available free at www.ASAP-utilities.com Vaya con Dios, Chuck, CABGx3 "Tat" wrote in message ... I would like to add a color to every other row in a specified row/column range. In addition if a row is inserted I would like it to continue the color pattern of every other row being colored. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) |