vba help needed - please

[gloworm]

I have an excel workbook that I need to put some conditioning on.

for example:

column e - if the value of the cell is between 100 and 200 then it is green, anything else would be red. The values should be bold too, in this column.

column j - if the value is greater than 200 green, under is red. bolded again.


I did some of this years ago but have been out of the loop and did not realize how much I have forgotten. I have been looking for an answer but nothing is looking right to me.

I was out of work for a while and had to do something. i got in a little over my head. I don't need to lose this gig cause I have a kid on the way.

Any help is appreciated.

 

[RSXchin]

conditional formatting
between 100 and 200
click on the format button, choose green fill, and bold text
click stop if true

less than 100
OR greater than 200
red
stop if true

 

[gloworm]

I dont understand where I am supposed to use that.

sorry

 

[RSXchin]

Highlight column E and go to the toolbar and click Format, then Conditional Formatting. You should be able to get it after that.

 

[gloworm]

how do i put it into vb so that it can run more than once?

 

[RSXchin]

you don't need to put it in VB. It runs the rules everytime you change something.

 

[gloworm]

I got this going, thanks for all the help.

However, I have another issue on how to do something in the conditional formatting. I have looked for over an hour and cannot find it.

I need to format on the following conditions:

if cell 1a has a value of 46 and cell 1b is between 54 and 56, color cell 1b green and bold, others where 1a equals 46 would be red and bold.

if cell 1a has a value of 56 and cell 1b is between 47 and 53, color cell 1b green and bold, others where 1a equals 56 would be red and bold.

if cell 1a has a value of 66 and cell 1b is between 46 and 50, color cell 1b green and bold, others where 1a equals 66 would be red and bold.

This will need to continue for all of the data in the column. Each cell till the end of the data will need to use this to determine its color.


Thanks for the help.

 

[RSXchin]

Highlight the entire B column, and when you're doing the rules, pretend you're only doing it for B1.