How to include font and colour when referencing a cell

Mar 5th, 2002, 08:04 AM

I have a row of cells filled with data. Some are black, some are red, adn some are bolded numbers. I'm referencing these cells (ie. typing =a40, then dragging that formula accross). I want the numbers I reference (copy?) to also have the font/colour of the cells I have referenced. Mine are all appearing with regular font/colour. I can't hard code the cell with the desired font/colour as it will be changing. Any ideas??
Thanks!!

Lewis · Mar 5th, 2002, 10:23 AM

Use paste special select all

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 08:04 AM	#1
Guest Posts: n/a	I have a row of cells filled with data. Some are black, some are red, adn some are bolded numbers. I'm referencing these cells (ie. typing =a40, then dragging that formula accross). I want the numbers I reference (copy?) to also have the font/colour of the cells I have referenced. Mine are all appearing with regular font/colour. I can't hard code the cell with the desired font/colour as it will be changing. Any ideas?? Thanks!!

Mar 5th, 2002, 10:23 AM	#2
Lewis Board Regular Join Date: Feb 2002 Posts: 50	Use paste special select all