Even with VBA...If the cell contains a formula, subsets of the evaluated results cannot be formatted individually.