Condtional Formatting based on percentage and insert cell based on percentage

I have a workbook that I've built for a project. I've attached a sample workbook. What I'm trying to do, for the entire sheet or workbook if possible, is turn any Cell with a percentage of 30% to 49% yellow and any cell with a percentage of 50% or more Red. I would also like to move the ID's of the variable cells, for example Id number 9922, to the cells beside the description of the rows, Affected would be an example, if the information contained in the same row as the ID meets with a set of variables. For example I only want the ID's moved if they correspond with IDsub 1-25. One more thing, the people who will be using this spreadsheet will be copying data from a website when it is imported it does not insert the values as numbers. I would like to format the cells, in example workbook they would be any of the cells labeled ID IDsub Variable or Number, so that anything put in that cell will automatically be converted to a number. Any help I can get with this would be much appreciated thank you.
I should also probably add that the formatting will be done on approximately 80 rows a sheet with 47 sheets. Anything that could apply the formatting to all of those would be great.

Red: =S3>0.49
Yellow: =AND(S3>0.29,S3<0.5)
Applied to: $S$3:$AF$3
------------------------------
I do not understand part 2.