"X_HOBBES" wrote:

I think Condo might be looking for an automated solution so if he updates
the cell on Sheet3, the color automatically changes. If that's the case and
if you have only 3 conditions (red, yellow, green), then the easiest
solution is to use Conditional Formatting (click Format -- Conditional
Formatting...).

Here's how:
Assuming Sheet1 is your summary sheet and that you want the number & color
to show up in cell A1, then do this...

1. Set your formula to copy the cell value from Sheet3 (A1 =Sheet3!B5 or
whatever your source is)
2. Click Format -- Conditional Formatting
3. Specify 3 conditions, one for each color.
- You can use the default "Cell Value Is" and specify "equal to" and
"1". Then set your formatting (change the color to green)
- You can use a formula such as =if(A1=1,TRUE,FALSE) and then specify
your formatting

Conditional formatting allows for up to three conditions. It's a little
tricky at first, but once you get the hang of it, you'll find it extremely
useful -- I use it all the time!

X_HOBBES


"Fredrik Wahlgren" wrote in message
...

"condo" wrote in message
...
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??

Use Copy followed by Paste special. If you want both number & color, make
sure "All" is selected.

/Fredrik




Thank you X_HOBBES. It did what I was looking for.