Coloring rows based on criteria

Greetings:

We work with attached spreadsheet daily to track our backlogged orders. To this point we are manually setting the colors based on conditions, but we'd like to convert this to a macro if at all possible. For the past couple of weeks I've been researching this, but to this point I haven't been able to come up with much. I've looked at each of the related questions on the forum, but given that we need to colorize and bold the entire column based on the value in a single cell I'm not sure how that would work actually.

What we need to do are the following:
1 - Highlight any bin row in blue bold where Cell En (where n is the current row being evaluated) is greater than the value contained in 'Daily Metrics' Cell C1
2 - Highlight any bin row in red bold where Cell En (where n is the current row being evaluated) is greater than the 2 times the value contained in 'Daily Metrics' Cell C1
3 - Highlight in red bold any value in column D (D5 to the last row with data in it)
4 - Highlight in red bold any line in the Daily Metrics worksheet where the value in the cell An (where n is the current row being evaluated) is greater than 10% of the value in cell B1, rows 6 through the last non-blank row in Column A
5 - Copy the value in 'Daily Metrics' Cell C1 and Paste it using Paste Special, Values to 'Daily Trend' Cell Bn (where n is today's day of the month (for example, if today were February 13th, it would paste to Cell B14))
6 - Copy the value in 'Daily Metrics' Cell C2 and Paste it using Paste Special, Values to 'Daily Trend' Cell Cn+1 (where n is today's day of the month (for example, if today were February 13th, it would paste to Cell C14))
7 - Copy the value in 'Daily Metrics' Cell C3 and Paste it using Paste Special, Values to 'Daily Trend' Cell Dn+1 (where n is today's day of the month (for example, if today were February 13th, it would paste to Cell D14)

If you can help get us started we'd very much appreciate it. Thanks in advance.

Marcus