$$Excel-Macros$$ Change of colour of cell if i put new value

2016-03-06 Thread big smile
Respected My friends In the table above from cell c5to h8 all cell colour is yellow I want to make conditional formating in such way that if I make correction or write new value then that cell colour become normal or white This is required so that I can come to know whether I have change the

$$Excel-Macros$$ Need some help with sports related vba macro, sample file attached

2016-03-06 Thread miscjh
In the attached sample, which is only a snippet of a large worksheet, the goal is to have the player name with his total MLB stats for the season and the current team name. So in a nutshell, the first occurence of the player name is row i need, but I have to replace the string "TOT" with the

$$Excel-Macros$$ CONDITIONAL FORMAT & SOME BREAK OF CELL IN THE NEXT LINE

2016-03-06 Thread big smile
Hello Friends In the attached file I want the conditional formating based on the two conditions 1] Which is if f5 cells falls within 15 days then all cell from a5 to g5 become yellow which is at present working I want that this condition work only IF cell k5 is only " INF" If there is some thing

Re: $$Excel-Macros$$ Macro Require

2016-03-06 Thread jayendra gaurav
please support me. On Mon, Feb 29, 2016 at 6:19 PM, jayendra gaurav wrote: > Dear All, > > > I have 1150 separate files of part list Variant wise. and other hand I > have part list can you please suggest way that how can I search part usage > quantity of each part no