range Value

[Sharp]

Hi,

Im using the following to set a value of greater than 1

Please Login or Register  to view this content.

If Rng.Value > 1

Please Login or Register  to view this content.

however i want to be able to say greater than 1 and less than 5

Can anyone help

thanks

[NBVC]

You mean

Please Login or Register  to view this content.

[Sharp]

Hi,

continuing from my first post

Im using this code to say, if the value is between 1 nd 5 in column B then enter "Complete" into column 'P' in the row where the number is entered.

Please Login or Register  to view this content.

However as well as doing this i want the whole row that the number is highlighted on to be highlighted bold

any ideas

thanks

[NBVC]

Try:

Please Login or Register  to view this content.

[NBVC]

tRY

Please Login or Register  to view this content.