Transferring formatting attributes to another cell.

N

Neal

=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?
 
T

T. Valko

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
 
Top