VBA/Conditional Formatting Help

[McKnze21]

Hi All,

1st time post so thank you for letting me in to the forum!!

I am a bit of a novice with the spreadsheets but I wouldn't say I am completely clueless!

Anyway, my question is I have a spreadsheet for my accounts so on sheet 1 is my bank statement. I filter the statement in to months then manually copy any expenses from that month to it's sheet. So for example, April expenses will be Sheet 2 names "April 2019". Now for the month of April on Sheet 1 it's not all expenses, so I want my expenses to go a certain colour.

Does anybody have any assistance with a formula, Conditional formatting or VBA to make all this easier? I do so much manually but would love to have a spreadsheet where I simply enter in values and it does so much for you!

Thanks in advance!

 

[amiroo]

Hi,

I don't know what exactly you want. if you want create a report to view your expenses I recommend you use PivotTable.

To have better advice please share a sample file.

 

[McKnze21]

Hi,

I don't know what exactly you want. if you want create a report to view your expenses I recommend you use PivotTable.

To have better advice please share a sample file.

I used Conditional formatting so that when I selected a value from a drop down list, that whole row would be coloured a certain colour. Is there a quicker way to do this using VBA? Or any other way?

I would then like that row copied to the sheet for that month. So for example, all "Accomodation" that is dated April, I want added to table in April 2019 Sheet?

 

[McKnze21]

I have so many that I want to change the same colour. so for example with conditional formatting I have asked that it changes a row to light blue if it has "Accomodation" in drop down. However, I also want rows changed to light blue if it has "Meal", "Travel", "Pension"... So do I need create individual rules for each one? If so then this why I thought VBA be quicker than conditional formatting