VB Macro In Excel 2003

J

jlab13

I'm trying to make a vb macro for a sheet in excel. The sheet has
inventory quantities in every other column. I would like for any
quantity count under "10" to turn red. Anything "10" or greater to stay
black. I'm not a programmer really. Could anyone suggest some syntax
ideas?

Thanks for any help!
 
N

Niek Otten

Look at Format|Conditional Formatting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm trying to make a vb macro for a sheet in excel. The sheet has
| inventory quantities in every other column. I would like for any
| quantity count under "10" to turn red. Anything "10" or greater to stay
| black. I'm not a programmer really. Could anyone suggest some syntax
| ideas?
|
| Thanks for any help!
|
 
J

jlab13

Niek said:
Look at Format|Conditional Formatting

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm trying to make a vb macro for a sheet in excel. The sheet has
| inventory quantities in every other column. I would like for any
| quantity count under "10" to turn red. Anything "10" or greater to stay
| black. I'm not a programmer really. Could anyone suggest some syntax
| ideas?
|
| Thanks for any help!
|
Click to expand...


That's definately exemplifies what I'm going for, but is there a way to
apply it to an entire column? Right now, even if I have a whole column
selected, it only applies to the first cell. I have about 1000
inventory totals per sheet. Not sure I'd be able to do every one
individually without weeping over losing that many days of my life! :)

Thanks either way!!
 
N

Niek Otten

<even if I have a whole column selected, it only applies to the first cell>

I'm not too sure. It may look like that in the dialog, but do check and see in the "normal" sheet view. Maybe more cells are
involved than you thought.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Niek Otten wrote:
| > Look at Format|Conditional Formatting
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | I'm trying to make a vb macro for a sheet in excel. The sheet has
| > | inventory quantities in every other column. I would like for any
| > | quantity count under "10" to turn red. Anything "10" or greater to stay
| > | black. I'm not a programmer really. Could anyone suggest some syntax
| > | ideas?
| > |
| > | Thanks for any help!
| > |
|
|
| That's definately exemplifies what I'm going for, but is there a way to
| apply it to an entire column? Right now, even if I have a whole column
| selected, it only applies to the first cell. I have about 1000
| inventory totals per sheet. Not sure I'd be able to do every one
| individually without weeping over losing that many days of my life! :)
|
| Thanks either way!!
|
 
Top