Thread: Transferring formatting attributes to another cell.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neal Neal is offline
external usenet poster
  
Posts: 63
Default 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?
Reply With QuoteReply With Quote