I am trying to highlight blocks of 3 rows so I have been using the following formula:
=MOD(CEILING(ROW(),5),2)=1
I want it to start in row 2 though, so the following happens:
Row 1 = Blank
Row 2,3,4 = Fill
Row 5,6,7 = Blank
etc
I have tried only highlighting the range that I want to fill but it still starts in row 1.
Does anyone know how to do this?
Is this?
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
See http://www.mrexcel.com/articles/gree...g-in-excel.php or google excel greenbar banding
Entia non sunt multiplicanda sine necessitate
Yeah that works. Thanks very much!
is good that your problem solved:D
Please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
Edit- same post.
Hi again,
Your suggestion solved my problem, but I'm doing this for a work spreadsheet and we use Excel 2003. I have another spreadsheet that I'd like to do the same thing for, but there are already 3 conditional formatting rules applied so I can't figure out how to get this to work. Is there a way to have 4 conditional formats with Excel 2003 or can this be done using VBA?
Maybe VBA can solve your problem.
So what is your question? You want post a new thread, because is a different question?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks