Conditional Formatting HELP

[geohow1993]

Conditional Formatting HELP, is there a way to apply the same rules from one set of cells to the whole sheet?

i have a worksheet (see attached Book1.xlsx) where i have 5 rules that apply to one set of cells, for example the cell B10 has a dropdown of four options, and when i click on one, it fills that cell and looks to the options in cells O8:O12 (mix Status) then bases on what that says the cells change color (see cell B10 and try the options to see what happens)

obviously it is a lot of work to apply to each cell group (2 groups per day across 9 mixing tanks) is there a way i can copy the conditional formatting so that it applys to just the cells in the group as to save time in adding the formula over and over again?Book1.xlsx

[josephteh]

Try this CF formula:=INDEX(B8:B$34,IFERROR(1/(1/MOD(ROWS(B8:B$34),3)),3))=$O$9, applies to: =$B$8:$K$34.

[geohow1993]

Thank you, this is helpful, however the color affect the whole row, not just a group of cells like the example on the sheet. also i would like it to color the box that the text goes into as well

[josephteh]

Clear all your existing conditional formatting. Redo it with the above formula. $O$9 for "TO BE MADE" (blue color), $O$10 for "MIX IN PROGRESS" (orange color).. etc.

[geohow1993]

Auto Valet Production Plan Weekly.xlsx

Thank you, i have done that now, (see attached sheet) however the color isn't showing, i must have done something wrong.

[josephteh]

The CF formula is =INDEX(B8:B$34,IFERROR(1/(1/MOD(ROWS(B8:B$34),3)),3))=$O$9, and the range to cover is =$B$8:$K$34 for all.