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
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