Formatting background colors

R

Randy

Is there a formula I can use to change the background colors on specific
cells? I want to change the color on the even rows of 4 columns (A:D) to
gray. I know I can click on the areas to do this, but it is so time
consuming. I hope this makes sense. Thanks for any assistance.
 
S

Stefi

Select columns (A:D)
Format>Conditional Formatting>choose Formula from Condition1 drop down list,
formula is =MOD(ROW(A1),2)=0, >Format>Pattern, choose grey color!


--
Regards!
Stefi



„Randy†ezt írta:
 

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

Printing from Word my Inserted Pictures colors are dull and lack color 0
Changing row background from external program 0
Counting Colors of Cells set by Conditional Formatting 2
Changing language from UK to US English 0
Document Merge Formatting Issue 0
Upgraded from Win 7 to Win 10. Publisher printing black. 1
List all tables, including document structure 0
Columns appearing from nowhere, formatting going weird 0

Top