two conditions

Hello, I am looking to have a column of dates (column G) fill GREEN based off the conditions: 1. If there is a "P" (stands for portables) in column F 2. If the date listed in column G is over one year old (365 days+) I am also looking to have the same column of dates (column G) turn GREEN...

Hi there, I need help with a formula to apply conditional formatting based on two conditions. The data I am referring to is shown in the table below. The formula for the conditional formatting should format a cell based on the classic green, yellow, red formats when the row and column dates...

I need some help please with conditional formatting of some cells. I have a chart with the days of the week across the top, dates just below and then a shift pattern below that. What I currently have is two conditional comments that work, to display the column with an ‘S’ in it (ie. Weekends)...

I have a script i use to hide columns if the returning calculation= 'NR' and another similar script with I created if another cell = "0" to hide that column but the two cant run together- each script un-hides the previous script. (no matter what order they run in) Question: How do I join (or...

I am facing a problem making a table which contains the usage values of certain articles in Excel 2007. The table should show the monthly usage twelve months in history of a insertable value, for instance December, which I have inserted using =TEXT(O2;"00")&"-"&03. This first part works fine...

=SUMPRODUCT(SUMIF(INDIRECT(""&list&"!J$22"),"=1",INDIRECT(""&list&"!J4"))) This formula works great for summing cell J4 across 94 sheets based on the condition that J22=1. However, I can't figure out how to add a second condition - K22=1. If anyone could help me modify this formula so that...

Hi All, First off, thanks in advance for any help on this. I've been reading/searching the forums for awhile now, but this is the first time I haven't been able to work out a solution to something from other posts, so here I am with post number 1. What I am trying to do is combine some...