Help keeping conditional formating when using IF function

williams02

New Member
Joined
Dec 7, 2016
Messages
2
I have 2 separate sheets one has a NBA information on it regarding teams DvP and like how many points,assist,rebounds they give up to each position on average. On the other sheet I have players that are playing today and i used the IF function to bring over how the opposing team does against that persons based on there position. I have each of the teams DvP stats conditional formatted based on the position and certain stat. Now to my question I am wondering if it is possible that when I bring over say a PG's opponents points given up per game that I can bring over the conditional formatting off that cell as well. Doing this i could have to numbers exactly the same but different conditional formatting because it would be a different position. I hope this isn't to confusing if need be I can try to post some pictures to explain better
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
welcome to the board

You can't easily pick up the conditional format of another cell - you'd have to have a straight "=A1" type formula that imports the value, and have the same format conditions on it, then have your formula next to it with it's own format conditions
 
Upvote 0

Forum statistics

Threads
1,214,839
Messages
6,121,887
Members
449,057
Latest member
Moo4247

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