format ='s another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can cell A1 have conditional formats and then have cell B1=A1 and have B1 then also automatically change its formats everytime A1 changes

Thanks
 
Hi
you have to apply the same conditional format in cell B1 as in cell A1.
Formulas can't transfer formats
 
Hi
also not really possible. E.g. if you change the format of your source
cell there's no event which is triggered to copy this format. the best
workaround would be to use a OnTime method (but this will slow down
your worksheet)
 
You must log in or register to reply here.

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

Display entire number in cell 3
Conditional Formatting macro: simple, but doesn't work 6
Time Calculations Help 4
Looking for a Date forming function 3
How do I reference cells in CF formula within loop 2
IF - formatting problem 8
Duplicate Digits 3
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2

Back
Top