Fomula where one cell is equal to the other cell content & format

  • Thread starter Thread starter blondie1279
  • Start date Start date
B

blondie1279

I want to be able to have one cell equal to the format and value of another
cell. So if I change the primary cell to strikethrough, it will
automatically change the other cell.
 
Formulas don't return this kind of stuff--they return values.

And event macros don't run if you just change the format of a cell.

You could use the worksheet_calculate event that would update the other cell
each time the worksheet recalculates. So your format could be one recalculation
behind.
 

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

How can I detect strikethrough formatting in a cell? 2
Conditional formatting - not equal to cell above 3
Conditional formatting for time 1
Format one cell in a row based on value of another cell in that ro 1
SUMIF using 2 cells that equal each other 1
Cell Color Formating 6
Excel Need Countifs Formula Help 0
Finding Text within an Array 2

Back
Top