Tag Info

New answers tagged

0

If you want to do this without a helper column, you can use this as your CF formula: =MOD(SUMPRODUCT(($A$2:$A2<>$A$1:$A1)*1),2)=0 Just select your formatting, and you're done.


0

Is this what you are looking for? You might need to create a column which numerically ranks each person


0

I would use the Power Query Add-In for this. It can combine data from multiple files into a single table, e.g. http://dutchdatadude.com/combining-excel-files-using-power-query-for-excel/ I cant follow your "minimum frequency" requirements, but Power Query has lots of other transformation capabilities. Perhaps if you can explain them in more detail and ...


0

I would use a slightly different approach to those suggested in the link, a bit simpler I think If your data is in columns B,C and D starting at row 2 then I would select the whole range and apply this formula in conditional formatting =OR(B2<>C2,C2<>D2)


1

I have tested this on Excel 2013: [Green]"+"0.00%;[Red]"-"0.00% NOTE: actually my excel is in another language with different decimal separator, so it looks like this: [Green]"+"0,00%;[Red]"-"0,00% but I assume yours use the dot as decimal.


0

Look up Time & Date functions in the Excel help. Example: WEEKDAY() will take a date and give back a numeric value, representing the number of days from monday (or sunday=1... sat=7, if you set the second argument to 1 instead of 0). Additionally TEXT() will allow to pick out portions of a "date & time" (using the same syntax as custom formatting), ...


0

The problem using DATEDIF is it doesn't calculate negatives. Microsoft states: Displays a #NUM! error because start_date occurs before end_date (#NUM!) Therefore, the rule doesn't run as you entered it. Since Excel recognizes dates, use the simple function of SUM on this and it works as you described. =SUM($N$9-N12)>=3 for green =SUM($N$9-N12)=2 ...



Top 50 recent answers are included