colours

I'd like to apply some fill colours to a grid which represents events (in rows) and dates (in columns) to make it easier to distinguish entries. I have manually applied fill colours to the columns. For the sake of argument, alternating columns are in one of three shades of grey. I would also...

Hi guys, Please could you help me write a macro (or conditional formatting if possible) for the following: I have a set of data listing accounts in excel. Each account needs to be updated twice an accounting period with a figure. To make sure that the user knows which account has not had...

Hi, I have a list of profit & loss variances between actual & budget. I am wanting to show all of these variances on a bar chart. The problem arises in that i am wanting to show positive variances as a green block and negative variances as a red block. Can this be done? Thank you, Mark

Hi, :confused: I've been running a Macro that highlights certain cells with a colour to enable better search results, However when i try to copy this information and paste it into another Excel document it does not take the colour highlight with it, even on a paste special?!? Is their a...

Hello I have a range of data which I want colour-coded if the date in a cell is different to the one above it. If it is the same as the date above it, I want the colour to be the same as that cell. The below macro almost works - it scans the range, and if the cell above it is different to...