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.

[FDibbins]

Hi and welcome to the forum

For the 1st part (color the cells) you can use conditional; formatting...

1. highlight the range you want to apply the conditional formatting to
2. select Format/Conditional Formatting
3. select Formula IS (from the 1st drop-down)
4. enter =F8="day" Format fill as needed.

If required, repeat this for "night" and change the color

Im not sure where you want the answer for part 2, but use this...

=SUMIF($F$8:$F$50,"day",$K$8:$K$50)

copy/paste and chage to "night

[sathiyamoorthy]

HI fdibbins,

GREAT...

CORRECTION...


BUT BY THIS CONDITIONAL FORMULA, ONLY CONDITIONAL COLOR WILL APPLY TO M8 ONLY...

SO NEED ADD THE $ TO YOUR FORMULA TO APPLY THE CONDITION TO THE ENTIRE SELECTION... =$F8="DAY"

THANKS,
SATHYA