MFW Diary - Take 1!

Lois_E

What colours do you want to use? 118 different ones?

gallygirl

No, just BRIGHT GREEN

or maybe PINK.

No, def GREEN :rotfl:

Lois_E

Oh I see, so you want it green if it's a different thousand bracket from the row above, and black otherwise? Is that right? At first I thought you wanted each thousand bracket to be a different colour all the way down from £118k to £0 so 119 colours. :rotfl:

Will get back to you when I've had a think how to do it. I have a few ideas already.

Lois_E

OK, here's how you do it.
Select one cell in your total column - but not the top one because we need another value in the row about to see if it's the same thousand bracket as that. Let's suppose it's cell E3. Now click on "conditional formatting" and select "manage rules", then "new rule" and "use a formula to determine which cells to format".
In the formula box, type
=INT(E3/1000)<>INT(E2/1000)
Obviously correct for the actual cell row and column on your sheet.
Underneath the formula box, click on "format" and choose bright green or whatever it is that you want.
Now click on OK, which returns you to the Conditional Formatting Rules Manager. Now change the "applies to" bit to cover the range you want - presumably all of your total column. (It doesn't matter at this point whether you include the top one or not - it will think it's a new thousand bracket if there isn't a number in the row above, or even if there isn't any row above at all.) Then click "apply" and the job's done.

PS Let me know if it doesn't work.

Lois_E

Oops. Sorry Calfuray. Didn't mean to hijack your thread for other people's Excel questions. Anybody else wanting Excel help, please ask me on my own diary to save cluttering up Calfuray's.

Calfuray

:eek: I'm going to ignore all these crazy formulae things going on.

Although Lois, how do I make a graph that only goes off certain columns of my spreadsheet? I know i can select it all and get a graph of everything, but sometimes I only want column A & E etc?

Before I go to bed, thought I'd post up list of non-money things to do before uni starts back up to remind/motivate myself:

• Declutter! Tidy allllll rooms.
• Finish meal plan for month, and try some new recipes.
• Look up exercises to do with new dumbbells.
• Go for half hour walk at least twice a week.
• Write some more.
• Learn Eclipse.

I'm sure there's something else, but too tired for now. Night all!

EDIT: No worries Lois, I like having some activity on my diary :rotfl:

Lois_E

Calfuray wrote: »

:eek: I'm going to ignore all these crazy formulae things going on.

Although Lois, how do I make a graph that only goes off certain columns of my spreadsheet? I know i can select it all and get a graph of everything, but sometimes I only want column A & E etc?

Probably the simplest way to do that is make one with everything, and then delete the bits you don't want. So select the graph, then right click and choose "select data". It'll give you a list of data sets corresponding to your columns, and you can delete the ones you don't want.

There are other ways of doing it, but I think that's probably the most straightforward.

Calfuray

Lois_E wrote: »

Probably the simplest way to do that is make one with everything, and then delete the bits you don't want. So select the graph, then right click and choose "select data". It'll give you a list of data sets corresponding to your columns, and you can delete the ones you don't want.

There are other ways of doing it, but I think that's probably the most straightforward.

Thanks Another one to annoy you with, I have separate spreadsheets that track balance of mortgage, one with no OPs, one with x amount, one with y amount etc. Do you know any quick way to make a graph comparing amounts over the separate spreadsheets?

And muchos progress made today. OH wants fibre BB which has just become available in our area. Would be extra £20 a month. Mortgage is currently £262.41 a month, so have agreed to BB as long as we change SO to mortgage to £300, so that'll be an extra £37.59 a month with no effort
Aaand, checked QuidCo, can get £45 cashback for car insurance he is about to take out, he was impressed.
First signs of cracking OH to dark evil MFW ways :L

skint_spice

mmm...fibre BB took me a wee while to work out - it's all the talk of loo roll and juicing everywhere, thought it was breakfast cereal for a mo:o

gallygirl

Calfuray wrote: »

Thanks Another one to annoy you with, I have separate spreadsheets that track balance of mortgage, one with no OPs, one with x amount, one with y amount etc. Do you know any quick way to make a graph comparing amounts over the separate spreadsheets?

No doubt Lois will come along to give an easy way....... but if it was me I would set up a different page, link the relevant columns through to it and then graph it.