Right, I've had a bit of a look round and can't seem to find a suitable solution to my problem.
Currently, my workbook has a VBA script on it that searches for and highlights rows based on the criteria entered in a textbox, this works quite well but I'm trying to come up with an easier way of setting up this spreadsheet.
Currently, the data in my sheet is entered in columns A-K. Then there are 3 hidden columns containing lookup data for some drop down lists. The script looks through the data in 1 column and will highlight the entire row (or will ignore it) based on what date(s) I am looking for.
What I'm intending on doing is trying to come up with a better looking way of being able to format the sheet based on set criteria, in order to highlight what items on the sheet need urgent attention.
Basically, I was thinking about using conditional formatting and/or a script that will colour JUST columns A-K and not the entire row as far as it does along the worksheet, just to keep it looking a bit tidier, not really sure how to go about it so a few pointers would be appreciated
Currently, my workbook has a VBA script on it that searches for and highlights rows based on the criteria entered in a textbox, this works quite well but I'm trying to come up with an easier way of setting up this spreadsheet.
Currently, the data in my sheet is entered in columns A-K. Then there are 3 hidden columns containing lookup data for some drop down lists. The script looks through the data in 1 column and will highlight the entire row (or will ignore it) based on what date(s) I am looking for.
What I'm intending on doing is trying to come up with a better looking way of being able to format the sheet based on set criteria, in order to highlight what items on the sheet need urgent attention.
Basically, I was thinking about using conditional formatting and/or a script that will colour JUST columns A-K and not the entire row as far as it does along the worksheet, just to keep it looking a bit tidier, not really sure how to go about it so a few pointers would be appreciated
