title: Excel 2007 vba if statement fill cell colour based on precious cell colour
body: <p>please help me,  i have no idea how to work with colours in vba coding.  am gonna try and explain this as simple as i can.</p>
  
  <p>i have cells from D3 to AH564 that has no values in them and never will.  if i change the colour in any of these cells to blue, it must change the cell that is 14 cells next to it(R1C14) to green then again 14 cells blue and again green.  just three times.  and if i change a cell to green do the same thing.</p>
  
  <p>i have tried several codes found on the site and modified them to my needs but all of them uses values and i dont know where to even start with colours.</p>
  
  <p>background colours are as follows:
  Blue (RGB) 0, 112, 192
  Green (RGB) 146, 208, 80</p>
  
  <p>i want the macro to change the 14th cell to the other colour 3 times.</p>
  
  <p>thanks for all the help.</p>