If a cell equals a date 18/01/08 for example which would be a Friday
the cell number is set to ddd dd " Fri 18"
Is there a conditional format formula I can use to trigger on a Friday only?
...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/22/2008 Rating: 9.2 Views: 0
I open an Excel document on my Mac that was created on a PC, and the dates change. They should be 16-Jul-09 but show up as 17-Jul-13. I found one other person who had the same issue but it was ba...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 07/17/2009 Rating: 9.8 Views: 0
Hi
I was wondering if it is possible to have a vlookup (or some other fomula), that gives the nearest match, but not an exact match. As per attached spreadsheet.
Greg
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/28/2009 Rating: 9.3 Views: 0
Heres the deal.... in excel 2007 i installed some add-ins to use with a software called showcase 7.1, it installed properly, but, now all of a sudden everytime i start up excel i get an errro mess...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I have multiple 5 line records separated by a blank line. I need the 4th line and the 3rd line to exchange places, i'm pretty sure there's a macro to do so. Any help is appreciated.
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hello,
I need a Macro that Loops through column C. Every time that the value in column C does not equal the cell directly above it, add a new row above the cell.
Any help would be appreciat...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/09/2008 Rating: 9.3 Views: 0
Has anyone witnessed this before, or know how to prevent it.
I am running a simple SUM() formula across 2 cells. The 2 source cells are formulaic themselves. Excel seems to be adding in an error...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/03/2008 Rating: 9.1 Views: 0
If cell has word lowor mod low than use one color, mod or mod high in one color, high or extreme high in one color. I've tried using If Value between but it treats all the one started with Mod a...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_244...
I have setup a named range called MYRANGE to be a dynamic source for a pivot table. In other words, I have defined the pivot source as MYRANGE. When I originally created the named range it was a ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I am using Combo box to display 7 level of prices but after you select the dollar amount the cell will only show as number without dollar sign. I've tried to format the cell as currency or account...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/22/2010 Rating: 6.6 Views: 0