I want to specify certain values to a specified color and i do not know how to go about this. E.g. value of 60 - black color and value of 30 - red color. How do i do this?

You could perhaps start with this UDF

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

You could do this with conditional formatting.

Home/Conditional Formatting/

Highlight cells rules... follow the instructions!