How can I reffer a cell format from other cell?

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?
 
S

Sheeloo

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditional Formatting 1
Question 1
How to add a space after each text value in all the cells in a row 4
Need help for a formula 5
Skip Reference Sequences during copy 3
Hide Cell content from Printing 2
Report data from cell if dates match 2
Average problem 1

Top