excel 2010 formatting

Hi all, I am developing a dashboard to convey a heap of information in the most visually appealing way possible and am having trouble with some VBA code. I am trying to write some code which will shift the formatting between a print view (which is mostly black and white) and a normal view...

I am working with Excel 2010. Each cell in my spread sheet column has some requirements text and a 'Note:' for that requirement. Sometimes there are two 'Notes' in one cell. The text in each cell looks like this: The user should be able to see all fields mentioned in 'access request...

All, I have an issue with Excel 2010 spontaneously changing coloring of some cells. I have a simple VBA macro which creates and populates sheets in a new workbook, copying all formatting information from the original workbook. Occasionally the formatting gets changed while the macro is running...

Hi! i'm new in vba. and i can nothing about conditional formatting. so i wonder if some one can help me with the conditional formatting. that marks duplicated value in 2 column. something like this. column B column C column D column E column F column G nameA...

Hi, What is the way of changing chart defaults (other than making new templates), especially the chart size, 'legend' font size, 'axis items' and 'axis title' font size, 'chart title' font size? The change can apply to all the chart types in excel. Eg. 1. The legend size is set to 10 by...

Hi there, I have a bit of a problem with Conditional Formatting (CF) in Excel 2010 when copying data that contains Rules to another worksheet. It is making the references absolute to the Worksheet 1 that it was copied from and not leaving them as relative to the worksheet they were copied...

Hello, We are using Excel 2010 and have a workbook with multiple worksheets/tabs. We have grouped rows on several tabs which work properly and which display the grouping [+] plus and [-] minus signs...

ok i am working on this this excel program and i have just about finished it, but i cant for the life of me figure out how to make a range of number EX(0-100) to apear in a cell in that format. I am trying to calculate the BMI of people. Now the BMI has a range in itself. Like it goes up to 18.4...

I have a table setup that drives my pivot table. My pivot table then drives my chart. I have identical conditional formatting applied to both the table and the pivot table, but need VBA to assign the same conditional formatting to the chart. The chart will change month by month so the values...

HI, Am trying to make a holiday entitlement document for my business and need some help on the formulas as am rubbish on excel. I have found a excel doc on this site but cant get it to work. Start Date 25/03/2010 Staff Name Hol Year Start Hol Year End Accrual Start Date...

I am trying to highlight rows in my Excel spreadsheet that contain the same data. I have tried using 'Conditional Formatting,' 'Highlight Cells Rules,' 'Duplicate Values' option. However, this highlights any cells that contain the same information. I only want the entire rows highlighted that...