Transferring formatting attributes to another cell.
 

=IF(SUM(K9:K34)<K4*COUNT(K9:K34)*($AJ3),K2,"")

cell K2 has been formatted so the text is blue, how do i get the cell to
format itself blue, should the "if" statement be true, in such a way that
only changing the formatting in cell K2 would change the formatting in this
current cell?

Transferring formatting attributes to another cell.
 

Formulas can't "bring" a format with them. You'd need to use conditional
formatting to test that the result of the formula is equal to K2.

Biff

"Neal" wrote in message
...
=IF(SUM(K9:K34)<K4*COUNT(K9:K34)*($AJ3),K2,"")

cell K2 has been formatted so the text is blue, how do i get the cell to
format itself blue, should the "if" statement be true, in such a way that
only changing the formatting in cell K2 would change the formatting in
this
current cell?