ExcelBanter - Formatting background colors

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formatting background colors (https://www.excelbanter.com/excel-worksheet-functions/260878-formatting-background-colors.html)

Randy

Formatting background colors

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.

Stefi

Formatting background colors

Select columns (A:D)
FormatConditional Formattingchoose Formula from Condition1 drop down list,
formula is =MOD(ROW(A1),2)=0, FormatPattern, choose grey color!

--
Regards!
Stefi

€žRandy€ ezt Ã*rta:

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.

All times are GMT +1. The time now is 05:36 PM.