I've tried using VB in Excel based on some posts that I have read, but I'm sill having zero luck! What I'm trying to do is a two step process.
1) Getting the Tab name to change based on a name in a given cell.
i.e. - If cell A1 is Dan, change the Tab to say Dan. (There isnot a set list of names, it could be any name possible)
2) Change the tab color if cell C74 is:
Cell Value >=80, change to Green
Cell Value between 60 and 80, change to Yellow
Cell Value <=60, change to Red
Again, I've never really used VB, so if someone could give me the formula so I can cut and paste it into VB, that would be awesome! Also, once I paste it into the VB box, what is the next step to get it to work.
Thanks for any assistance in advance!
Bookmarks