"coloring" lines without formatting it

struf

Board Regular
Joined
Jul 2, 2002
Messages
107
I have looked on the board for this, but am having no luck, probably because I do not know what i should call this.

I want row 90 , 180, and 270 green. Easy enough.
BUT.... if i insert another row, say by row 80, i still want the original rows 90, 180, and 270 to stay green; I do not want row 91, 181, and 271 to now be green .

I want these to stay green as a benchmark for people using the spreadsheet. this spreadsheet is being used in another worksheet so anything over 90 rows plays havoc on my output, therefore i would like a benchmark to assist them in not going over that amount


I have been playing with different formats, but have had no luck.

Any suggetions would be appreciate

as always, many thanks in advance

--struf
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

You can use Conditional Formatting:

1. Highlight the area of the sheet you are interested in eg rows 1:300 say
2. Change to Formula Is and type in:

=OR(ROW()=90,ROW()=180,ROW()=270)
3. Choose the Format you want (eg Green Pattern)
4. Click OK

Best regards

Richard
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,531
Office Version
  1. 365
Platform
  1. Windows
struf

This may also be of use. It is similar to Richard's but only requires two function calls and, if enough rows are added within the data area, would also make rows 360, 450 etc green.

1. Highlight the area of the sheet you are interested in eg rows 1:300 say
2. Format|Conditional Formatting...|Formula is: =MOD(ROW(),90)=0|Format|Patterns|choose green|OK|OK
 

struf

Board Regular
Joined
Jul 2, 2002
Messages
107
Excellent.
Thank you both for the options.
This board has always come through for me.
Thanks you again..
 

Forum statistics

Threads
1,141,097
Messages
5,704,314
Members
421,338
Latest member
Pepess

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top