I'm new to VBA in Excel and I'm trying to do something that sounds simple to me, but I can't work out how to do it.
I want to fill the colour of each row in my worksheet based on the contents of one of my columns.
e.g. if column D contains "Paid", I want the row to be coloured green. If column D contains "Not Paid", I want the row to be coloured Red, etc.
My data is loaded via a query to a MySQL database, so I want the colouring to be done dynamically when I load the spreadsheet, and also when I refresh my data.
I'm using Excel 2000.
Thanks in advance for any help.
I want to fill the colour of each row in my worksheet based on the contents of one of my columns.
e.g. if column D contains "Paid", I want the row to be coloured green. If column D contains "Not Paid", I want the row to be coloured Red, etc.
My data is loaded via a query to a MySQL database, so I want the colouring to be done dynamically when I load the spreadsheet, and also when I refresh my data.
I'm using Excel 2000.
Thanks in advance for any help.