How can I reffer a cell format from other cell?

  • Thread starter Thread starter Kaz
  • Start date Start date
K

Kaz

I would like to reffer other cells color format to reffered cell.
If I put " =A2 " on cell B2, only value on cell A2 copyed to cell B2.
Can somebody help?
 
You can not get another cells format using a formula.

You can copy and paste the format through Paste Special but it won't change
based on the formula result.

You can have upto 3 (Excel 2003 and earlier) formats based on cell value or
formula based on cell value...
 
Back
Top