Software. How Do I Create A Formula On Excel Which Duplicates The Format Of One Cell To Another Automatically?
Software. M/S Excel 2003, Does Anyone Know How I Can Creat A Formula That Dedects What Colour The Cell Is And Then Automatically Updates Another Cell
Software : How Do I Create A Formula On Excel Which Duplicates The Format Of One Cell To Another Automatically
M/S Excel 2003, does anyone know how i can creat a formula that dedects what colour the cell is and then automatically updates another cell with the same colour? ~~~ dee_windy ~~~
Best Answer To Software Question
It sounds like you should use the Format Painter. Select the cell that has the Format (color, font, etc.) that you want to copy and then click the Format Painter on your tool bar. (It looks like a little paintbrush.) Then click on the cell that you want to copy the format to. I'm not sure from your question, but it almost sounds like the colored cell may be changing color and the other cell needs to be automatically updated. If this is the case, I would use Conditional Formatting instead. Let me know if you need more help.
All Answers To Software Questions
Answer 1You need to write a macro. Format your cell with its colour, select it - Give it a name, in top left box where the cell name is - select the cells/column/row you want to update - give them a name. Go to Tools - Macros - Record Macro. Press F5 (go to) select the name from the drop down list or type it in - click OK - Copy - Click F5 go to the second named cell/row/column as before - Paste. Close name and save Macro Set it to run automatically. Hope it works. its a long time since I did it!
Answer 2It sounds like you should use the Format Painter. Select the cell that has the Format (color, font, etc.) that you want to copy and then click the Format Painter on your tool bar. (It looks like a little paintbrush.) Then click on the cell that you want to copy the format to. I'm not sure from your question, but it almost sounds like the colored cell may be changing color and the other cell needs to be automatically updated. If this is the case, I would use Conditional Formatting instead. Let me know if you need more help.
Answer 3Right click the 'sheet' tab at the bottom of the screen. Click 'View Code' Paste the following code into the screen you get ----------------- Private Sub Worksheet_SelectionChange(ByVal Target As Range) = False Cells(1, 1) Cells(2, 1).PasteSpecial Paste:=xlFormats = True End Sub ----------------- What this code basicly does, is it tells Excel that everytime there is a selection change it should copy the format from A1 "Cells(1, 1) You can adapt this code as you see fit.
Answer 4try edit/copy/paste special/format
62 Ways To Save Money At The Gas Pump
You don't have to ride your bike 40 miles a day to save money on gas.
When it's not reasonable to walk, bike, or take the bus to the places you need to get to - something needs to be done to cut down on gas prices that empty your wallet faster than the IRS.
Do you find yourself driving on empty hoping you can make it until payday? Did you stop buying your food from your favorite restaurant so you could get to work the next week?
Are you just outraged that you're being forced to drop loads of money because the price of gas can't find a low number it likes?
These are issues we all deal with today. And none of them are cheap. The best we can do is make sure we get the most for our dime. Your money deserves that respect. Learn 62 Ways To Save Money At The Gas Pump
Education & Reference - Primary & Secondary Education Sports - Boxing Travel - Canada Sports - Water Sports Sports - Sports Cars & Transportation - Car Audio Local Businesses - Ireland Yahoo! Products - Yahoo! Bookmarks Politics & Government - Embassies & Consulates Business & Finance - Insurance Education & Reference - Studying Abroad Science & Mathematics - Physics Local Businesses - Spain Local Businesses - Local Businesses Education & Reference - Higher Education - University Cars & Transportation - Boats & Boating Entertainment & Music - Entertainment & Music Dining Out - United States Dining Out - France Travel - Africa & Middle East Sports - Snooker & Pool Society & Culture - Languages Dining Out - General Pets - Rodents Travel - New Zealand Politics & Government - Military Sports - Handball Science & Mathematics - Weather Pregnancy & Parenting - General Dining Out - Thailand Politics & Government - Elections Yahoo! Products - Yahoo! Answers Politics & Government - Civic Participation Sports - Auto Racing Travel - Europe (Continental) Education & Reference - Education & Reference Society & Culture - Etiquette Food & Drink - General Arts & Humanities - Poetry Arts & Humanities - History Sports - Cycling Food & Drink - Entertaining Cars & Transportation - Aircraft Consumer Electronics - Land Phones Pets - Reptiles Science & Mathematics - Earth Sciences & Geology Education & Reference - Financial Aid Travel - Travel (General) Entertainment & Music - Music Beauty & Style - Fashion & Accessories
Copyright 2008 SearchWebEngine.com, All rights reserved.
