Select specif range on Conditional Format

Hi,
I've managed to conditionally format a cell with VBA (im a vba noobie)
What I really want to do is format a range of rows.
Currently criteria from Column I and I want to color rows E to J.. I’m just not sure how to select the row. Is it Range.Select(), or Cell.Select() ?

I've commented my poor attempt in the code to select the appropriate rows.

Please Login or Register  to view this content.

Cheers
Cam

Cam

Not sure I follow. If I10 is .5, do you want E10:H10 to be colored green?

Is that what you want to do?

rylo

Hey Rylo,
Absolutley correct!

on another note when i enter a date somewhere i get a Compile Error on the code. It's slecting the first case (Case 0.1 To 0.69) in Yellow highlight. not sure whats happening????

Complete Code:

HTML Code: 

Hi

Try

Please Login or Register  to view this content.

rylo

Thanks Rylo! BIG HELP.