Vba Code for Color Change

[Diwas R Bhattarai]

Hi,
Need a help on following,
[FONT=Verdana, Tahoma, Nimbus Sans L, sans-serif]I have 4 selection on column G which includes Working, Left, Vacation, & Final Settlement. I need to Color cell column from A TO B if i select Left, Vacation or Final Settlement. Can you help me on this.[/FONT]
if The cell H value is left or vacation the cell A & B will be green and if its final settlement then it should be orange.
Let suppose i made Cell Value H4 = "Left" Then automatically the cell A4 & B4 should be Green Color. Same like if i made Cell Value H7 = "Final Settlement" Then automatically the cell A7 & B7 should be orange.
Rest of the cell won't be colored until i won't change their values.Regards
Diwas

 

[SteveO59L]

have a look at conditional formatting, no need for code