copying a cell's formatting to another based on cell value

[broadarmel]

Hello,
Is there a way to copy the formatting of a cell from one table to a second table based on the cell value?

Thanks!

 

[SteveO59L]

Have a look at Conditional Formatting

 

[Sektor]

[COLOR="Blue"]Sub[/COLOR] CopyBasedOnCellValue()
    [COLOR="Blue"]If[/COLOR] Sheets(1).Range("A1") > 10 [COLOR="Blue"]Then[/COLOR]
        Sheets(1).Range("A1").Copy
        Sheets(2).Range("A1").PasteSpecial xlPasteFormats
    [COLOR="Blue"]End[/COLOR] [COLOR="Blue"]If[/COLOR]
[COLOR="Blue"]End[/COLOR] [COLOR="Blue"]Sub[/COLOR]

 

[broadarmel]

I do not believe conditional formatting works for this.

To explain further-

Array 1: contains various color coded cost centers (ie. 00001) with total hours billed against them
Array 2: contains forecasted hours by project billed against the cost centers

When I input a new project into Array 2, I'd like the formatting to be updated automatically based on the cost center's formatting in Array 1.

To me it seems like there would need to be some sort of VLOOKUP against Array 1 to copy the formatting to Array 2, but I'm not a super excel user and do not know how to copy formatting with VLOOKUP or if it's possible.

Thanks.