How bring a color on cell from one sheet to another

[Guest]

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??

 

[Fredrik Wahlgren]

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

 

[X_HOBBES]

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

 

[Guest]

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




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