Formatting background colors

  • Thread starter Thread starter Randy
  • Start date Start date
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.
 
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:
 
Back
Top