Linking cell formatting between sheets

D

depcdivr

Active Member
Joined
Jan 21, 2008
Messages
349
Office Version
  1. 365
Platform
  1. Windows
I am sure that there is a simple way to do this but I am not sure how.

I have a master worksheet where I have a whole bunch of data. I have other sheets with cells that point to the master sheet (i.e. sheet1 Cell A4 has formula ='Master'!H4). I want the formatting of Sheet1 cells A4 to be linked to the formatting of 'Master'!H4. Can I do this without having to setup conditional formatting on EVERY single page?
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
You must log in or register to reply here.

Similar threads

M
  • Question
VBA to hide current sheet, then create new sheet from template
Replies
3
Views
179
Micron
M
J
  • Question
Automatically setting filters based upon user selection criteria
Replies
1
Views
156
John_w
J
S
  • Question
Date formatting issue sheet to VBA Array to Sheet
Replies
2
Views
155
MARK858
MARK858
R
  • Question
Auto Generate Timesheets Based Off Master Document
Replies
2
Views
377
RezLar
R
B
  • Solved
vba code to give next Sunday date for pasted data
Replies
2
Views
190
bh24524
B

Forum statistics

Threads
1,215,113
Messages
6,123,165
Members
449,099
Latest member
bes000

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top