Hello.. I need help with conditional formula in the Excel sheet that I have created

[Yussuf]

Hello All:

I am new to this forum and a novice in Excel world. I have created a Excel sheet with few formulas that I managed to learn from internet websites. Now, I have 2 issues with this excel.

I am attaching the Excel sheet I have created. The first issue I would like help with is I want the color of the entries in column M8:M49 to change depending on whether Day/Night selected in respective fields in column F8:F49. The second help I would like is to add the Day and Night output in column K8:K49 to be added separately .. day output and night output.

May be this sounds confusing, but I do not know how to put this forward. So, please excuse me for this, and any help would be greatly appreciated.

Thanks in advance.