color based on input

Hi, I have a market analysis sheet which is shown in the picture. As seen in the picture i have a column "p:p" where i can type in a date for each row. I want to make a code that colors the whole row green if its less than 1 year to the date, yellow if its more than 1 year but less than 2 years...

Hi I need your help in calculating the total sums of all the cells with yellow color. As per the example mentioned below are two columns mainly Name(C) and sales for the month (D) Now as you can see there are certain cells in the Name column (C) like C4,C7,C13 and so on which turn yellow. I need...

So I'm trying to make <5/10 red, 5-6.9/10 yellow, and 7-10/10 green. For the life of me I can't figure out how... S1ATS235,8/1045,5/1054,8/1066,3/1075,3/1086,1/109102,6/101110/10127,2/10S2:S12S2=IF(COUNT(O2,Q2),ROUND(AVERAGE(O2,Q2),1)&"/10","") Thanks in advance for any and all help!

now i have excel file with vba code that generate email in this generated email there is any way can i change last line color and font style in email body or must to write the code with html My file thank you in advance cross-posted 1 - https://chandoo.org/forum/threads/ca...y-excel.43311/ 2 -...

Hi, I have a very basic question about plotting data in Excel charts. My data contains two columns representing date and quantity and a third column which contains categorical values (see sample data below). I need to create a simple column chart with date on x-axis and quantity on y-axis and...

Hi I'm a little lost here, so hope someone can guide/help me. I having a Sheet1 where I have 7 rows Monday to Sunday and week number 31 to 52. The week numbers i'm getting by the formula AG5 = Weeknumber(Year!B2,2) And then AH5 = AG5 + 1 and so on, up to week number 52. Then I have another...

Is it possible to determine an argument if D2 is =< 50% of E2 to color format D2 and or column D?

Dear All, I think I need to write my very first VBA macro, but I have no idea on how to begin (other than how to open the VBA editor). Maybe I don't need the VBA but I don't know how to do it with the basic Excel functions. PLease note that I am working in excel 2010. So what do I want: I...

The above I posted a while back. Seems this can't be done in a formula. I know a bit of VBA, but doing what we want in VBA is not my strongsuit. If anyone can assist to acomplish above story in VBA I would be greatfull. The color part is the most needed for now, but the check would also be...