conditional formatting

E

excelguy

i want to color/shade row a2:c2, a30:c30 and every 28 rows after a30:c30 in
green. i think i have to use the conditional formatting but what should i
type in so I dont have to highlight thousands of rows manually.
 
E

excelguy

thanks for the website but Im not sure what to look for. It seems that they
are only telling me how to shade every other cell and not specific ones.
 
E

excelguy

this site actually just shows how to make a range of cells highlighted and
follow a pattern which is not what i need. I want to figure out how to
highlight a group of 3 cells every 28 rows! could you just write it out for
me if its not too mnuch trouble? thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

urgent- conditional formatting 1
Changing row background from external program 0
Indenting every other paragraph in Word at the same time? 0
countif on multiple criteria 1
Document Merge Formatting Issue 0
Conditional formatting a big size 4
Conditional Formatting 0
Conditional Formatting question.... 1

Top