Conditional formatting with VBA

[Tigger]

Hi Forum,
1st post so please be gentle :-)

I have read hundreds of posts but can't quite find an answer to my problem.
Seems pretty simple but now my ears are bleeding trying to work this one out.

Using Excel 2003:
Basically, I need to highlight any cell in a row that is equal to or less than a range set in column "J" of the same row.

I have attached a sample spreadsheet showing what I am trying to do.
Columns B:D show the effect I need using Conditional formatting
Columns F:H is where I'd like to achieve the same effect with VBA
Column J is the values I need to lookup in F:H and then format them via font or background, not fussed.

I can't use Conditional formatting on the final sheet as it won't work with another macro that converts it to HTML, this other macro just won't pickup the formatting when it's conditionally changed so I need to do it with VBA!

Any help as always would be gratefully accepted from you gurus :D

[sweep]

Hi,

Try replacing this

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

[Tigger]

Hi,

Try replacing this

Please Login or Register  to view this content.

with this

Please Login or Register  to view this content.

Sweep, you are a Guru indeed, you made it look sooo simple

Many thanks to you and the rest of the Forum for lots unsung help and hope you all have a very Happy Christmas.

Cheers

Tigger