Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jmor45
 
Posts: n/a
Default How bring a color on cell from one sheet to another

I have a summary sheet and I can do the numbers, but how can I bring the
color on cell?

Lets say, I have on sheet3 a cell with number one and color green; on
summary sheet I have a corresponding cell and I want not only th number 1 to
show up, but also the color green. Other numbers are 2 for yellow and 3 for
red. Can i ONLY WRITE THE NUMBER AND GET THE COLOR AUTOMATICALLY ON SHEET3??
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF command in Excel Lee Davison Excel Discussion (Misc queries) 1 April 4th 05 10:23 PM
Change workbook sheet reference using cell A1 to change a vairable Reed Excel Worksheet Functions 4 January 20th 05 07:15 PM
I want cell entry to be identical on another sheet NIMDRA Excel Worksheet Functions 1 January 10th 05 04:01 AM
Automatic cell increment with data from sheet 1 to sheet 2 Big G Excel Worksheet Functions 2 December 20th 04 05:59 PM
Cell Colors and Sheet Protection cincode5 Excel Discussion (Misc queries) 1 December 3rd 04 10:39 PM


All times are GMT +1. The time now is 05:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"