I have a row of cells A1:A10 then in A11 I have simple formula
=SUM(A1:A10)
Is there a formula I could use that would detect if one of the cells was fomated to a certain colour ie yellow that would then add 8 to the answer.
So if A1:A10 total was 35 but A8 was formatted yellow the toal would be 43.
=SUM(A1:A10)
Is there a formula I could use that would detect if one of the cells was fomated to a certain colour ie yellow that would then add 8 to the answer.
So if A1:A10 total was 35 but A8 was formatted yellow the toal would be 43.