View Single Post
  #1   Report Post  
condo
 
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??