Get instant live Excel expert help to learn how to color in excel cell

I am attempting to create a formula where one of the functions in Column B AND one of the functions in Column C, will give me a result in Column D. The formulas are on the second tab 'Risk Matrix'. In Column F, I would like the answer displayed automatically with the appropriate Fill color, depending on the reslut of the drop down list combination from D17 and E17.

When i filter material type or color, i want number back to 1,2,3, ... in sequence, and the sum total change adapt to my filter. so i can print them to show correct value.

how to change rows color based on text, for example when I type in "service" it changes the whole row to red. but when I type SOLD it changes the row to yellow

When I type "service" into a cell I want to be able to have the whole row change to the color red, but I want to be able to do that in any column as well. not limit myself to just one column. and how would i set it up for different Words like, when I type Sold it turns yellow

The attach excel file is a line plan of 18 Lines. Formula is in: Column "AM" is style number & Column "AN" is quantity. In worksheet A1 to AK1 column what the style number I start from any date , any line or multiple lines the total quantity I can get it “AN” column by SUMIF formula. Need: Column "AO" start date of a style number. Column "AP" Close/End date of the SAME style number. Date is in Column “A” I show an example of style number ABC (In Red color) which Start from Oct 15 & Close on 9 Nov. Close date I get correctly for all styles. But Start date is not working correctly. Can you please check the formula and correct it

Looking to be able to highlight a range of cells based off 4 drop down lists. The drop down lists are: days of the week, a list of tasks, and then a start time and an end time. I want to be able to pick the day of the week from the drop down, pick the task and pick a start time and an end time and have it highlight all the cells between the two times the color associated with each task. Thanks :)

Looking to be able to highlight a range of cells based off 4 drop down lists. The drop down lists are: days of the week, a list of tasks, and then a start time and an end time. I want to be able to pick the day of the week from the drop down, pick the task and pick a start time and an end time and have it highlight all the cells between the two times the color associated with each task. Thanks :) Can you just guide me in the direction I need to go? Or explain how I would go about it and I can go play around with it? I don't mind if it takes longer than 20 min

Looking to be able to highlight a range of cells based off 4 drop down lists. The drop down lists are: days of the week, a list of tasks, and then a start time and an end time. I want to be able to pick the day of the week from the drop down, pick the task and pick a start time and an end time and have it highlight all the cells between the two times the color associated with each task when I click a button. I know how to do the drop down lists and make the button, I just need the macro that would do the rest. Is there already a general one out there that I could look at and tweak to fit my needs? Thanks :)

I have cells color coded with no values (only sentences), is there a way to conditionally format excel to spit out a number for each different color? [ex: green fill=3.5, yellow fill =4]

In Állatlista sheett: If d13 contains the word Gazdisodott, and e13-f13=0, then please for the god sake g13 change its color to green... Id like to use it for the whole coloumn. Thank you for the help