Team,
I am using MS EXCEL 2010.
I have a spreadsheet where I am trying to conditionally format certain cells. Row 6 (Column A to NB) has values from 0.0 to 20.0. I want to format cell AJ8 using the formula, Sum(AD6:AJ6)>=56 (Fill the cell with the color Pink (RGB:255, 192, 203). Then in cell AK8 using the formula, Sum(AE6:AK6)>=56 (Fill the cell with the color Pink (RGB:255, 192, 203). etc...Basically I want the format to use the sum of the previous 7 cells of data.
Then I want to format cell AJ8 using the formula, Sum(W6:AJ6)>=80 (Fill the cell with the color Red (RGB:255, 0, 0). Then in cell AK8 using the formula, Sum(X6:AK6)>=80 (Fill the cell with the color Red(RGB:255, 0, 0). Basically I want the format to use the sum of the previous 14 cells of data.
Then I want to format cell AJ8 using the formula, Sum(G6:AJ6)>=80 (Fill the cell with the color Blue(RGB:0, 0, 255). Then in cell AK8 using the formula, Sum(H6:AK6)>=80 (Fill the cell with the color Blue(RGB:0, 0, 255). Basically I want the format to use the sum of the previous 30 cells of data.
Rows 8 through 200 (rows 6, 11, 16, 21, 26,etc... have the values) (Rows 8,13,18,23,28,33,38,etc... needs the fill of the cell to be formatted). I need the fill of the cells to format with a particular color if the sum of the previous 7 cells are >= 56, and another color if the sum of the previous 14 cells are >= 80, and another color if the sum of the previous 30 cells are >= 100, and another color if the sum of the previous 30 cells are >= 120.
This is four of the conditions i need. I would like to do this in VBA because I need 6 conditions for each cell. I need a total of six, but if I can get the first four, I think I can modifiy the code to do the last two.
Thank you in advance.