Linking only the format of a cell and not the data

  • Thread starter Thread starter Sandip Shah
  • Start date Start date
S

Sandip Shah

Hi,

I want to be able to automatically update the cells a13.e13 with the
colours that are put into a1.e1, but not to copy the content of cells
a1.e1.

Appreciate anyone help on this since most of the posting have a
solution for content and format simultaneously.

I want to link only the format and not the content.

Thanks in advance.
Sandip.
 
Hi
unfortunately you can't link formats. Even using an event
procedure like worksheet_change won't help as this event
is not triggered by format changes
 
You can't link format, but there are a couple of workarounds, depending
on your requirements.

- if the colors in A1:E1 are applied using Conditional Formatting,
you can use the same format conditions in A13:E13

- if you don't mind a delay, you can use an OnTime macro to update
every minute or so (you can update every second, but that will reduce
performance overall):

http://cpearson.com/excel/ontime.htm

- If your sheet updates frequently, you can use the
Worksheet_Calculate or Worksheet_Change event. Changing the format
doesn't trigger either event, unfortunately.
 
Back
Top