I'm trying to make a spreadsheet using drop down boxes. Each row has different cells of information concerning loans that i'm doing. And one drop down box in each row it has 4 words, opened, in process, withdrawn, & denied. I'm using the drop down box to show what status the loan is in. My question is...when i select a certain loan status..such as in process...i want the entire row containing the information to then have a background color of green. Also, when i select either withdrawn or denied, I want the row containing that loan and it's information to then have a background color of red. and lastly, with an opened loan, i want to have the background appear yellow. Can anyone here tell me the VB code or another way of doing this that would work? Thanks again for all your answers and your help!
2007-01-31 04:36:15 · 3 answers · asked by cbrkev98 1 in Computers & Internet ➔ Programming & Design
I don't know any VB codes but have you tried "Conditional Formatting". You probably created your dropdown boxes by using "Validation".
Try Conditional Formatting first. It's in Format>Conditional Formatting.
If it doesn't work the way you want it to then I'm sorry..
2007-01-31 05:03:11 · answer #1 · answered by drifter 2 · 0⤊ 0⤋
Try not to think in colors. It makes unreasonable demands on your color printers, useless in faxes and there are significant amount of people who are color blind.Words like opened, in process, withdrawn, & denied are fine.
Otherwise you have to run a macro to evaluate each cell and format the colors accordingly. A waste of time imho.
2007-02-01 02:39:07 · answer #2 · answered by unnga 6 · 0⤊ 0⤋
check out http://www.pscode.com for great sample codes...you can filter to VBA with Excel.
2007-01-31 07:22:40 · answer #3 · answered by Richard H 7 · 0⤊ 0⤋