Katametsj

 Excel normally calculates the formula in a cell when a cell upon which that formula depends changes For example, the formula =SUM(A1A10) is recalculated when any cell in A1A10 is changed However, Excel does not consider changing a cell's color to be significant to calculation, and therefore will not necessarily recalculate a formula when a cell color is changed7311 So =Cell("color",A1) would return a 1 if the value is formatted as Red (000), and a 0 if it had no color formatting Note that this has to do with the Number Format, not the cell color See Chip Pearson's site for how to deal with cell colors http//wwwcpearsoncom/excel/ColorsaspxIf ANY cells between c3 and g3 have a cell fill color of red then it needs to make cell b3 fill color red automatically This needs to also be a formula that i can apply to other rows also How To Use The Excel Cell Function Exceljet Excel cell color formula vba