Hi

Any ideas how to use conditional formatting cells with different fill color?

I want rows following:
1-4 with red
5-8 with blue
9-12 with red
13-16 with blue and so on.




-vemaju

__________________
-vemaju

This isn't really a coding question, unless you're planning on setting the conditional formatting with code.

In any case, set the conditional formatting like this:

From the spreadsheet:
1) Select entire spreadsheet
2) Click Format > Conditional Formatting
3) Click down arrow and change from "Cell Value Is" to "Formula Is"
4) Put this in the formula cell:
=MOD((ROW()-1),8)>3
5) Set color for that format to blue (Click "Format" Button and choose your conditional formatting)
6) Set the default color for the sheet to red and you're done. Or, optionally, you can add another format following these steps:
   a) Click "Add >>" button
   b) Click down arrow for condition 2 and change from "Cell Value Is" to "Formula Is"
   c) Put this in the formula cell for condition 2:
   =MOD((ROW()-1),8)<4
   d)Set color for that format to red (Click "Format" Button and choose your conditional formatting)

Hope this helps.

Hi Allen

Thanks for quick response.
Thats just what I want

I know how to to the trick with VBA but I want it happen automatically

-vemaju