Data Automation Help

[Tonyl1800]

I have a sheet that collects stats of numbers and puts them into 1st 14th in numerical sequence Columns H-U are numbers I enter and I highlight one of them to green. Is it possible to complete Columns X - AK and AO - CB automatically with the results of a calculation of the green highlighted and any other number having a -1 in X - AK

Thank you

[#2]

yes it can be done but only with VBA so it would be easier to use the same condition which was used for columns H-U. I guess there is a logic for why a specific cell was marked green in H-U, right?

[#3]

@PascalKTeam .. Thanks thats what I thought but struggling to work it out at this stage. The number is the Winners starting Price so that is marked on the sheet to make it stand out. Then X-Ak is the green number -1 * 5% and AO - CB is the highlight Green number -1

Thanks
Tony