Selecting field color

[abgoosht]

Hi everyone,
I've searched around, but my main problem is that i can't phrase it correctly enough on google to figure out what i want.

I'm trying to select the color of a field, and set the color of another field the same. Does that make sense?

Any help is greatly appreciated guys.

Thanks,

[Leith Ross]

Hello abgoosht,

Welcome to the Forum!

I assume by field you mean a cell on a worksheet. Are you wanting to do this manually?

[stnkynts]

Do you want to change the background color of a cell? A range?
Do you want to change the font color?
When i hear the word "field" as it applies to excel i think of a column.

[abgoosht]

Hey Leith!

Thank you.
Yes But I actually managed to figure it out. I came up with

Please Login or Register  to view this content.

But now I have a different question.
How can I select a cell that's on a different sheet, by name?
I tried

Please Login or Register  to view this content.

but no luck...

Thanks again!

[Leith Ross]

Hello abgoosht,

You don't need to select the cells at all. Without the period prefix on Cells, the default is the ActiveSheet.

Please Login or Register  to view this content.

[abgoosht]

Thanks a lot. I just came back to say I solved it, but dang it I'm late!!

Thanks a lot Leith.

I rally appreicate it.

-A