Conditional Formatting with VBA

[marreco]

I would like to format using VBA.
If the cell "B1" is greater today then the range "B1: B6" will be the color green.


If the cell "C1" then today is greater than the range of "C1: C6" will be the color Yellow.


If the cell "D1" then today is greater than the range of "D1: D6" will be the color blue.

Thanks

[tom1977]

try this

Please Login or Register  to view this content.

[jeffreybrown]

I guess the obvious question, why not just use the built-in conditional formatting?

[marreco]

Perfect! thank you!

[marreco]

hello jeffrey brown, my goal is to learn to use a little VBA.

I would love to learn.

[jeffreybrown]

Nothing wrong with that

You might find this useful...

http://www.mrexcel.com/forum/showpos...97&postcount=5

[tom1977]

if you want lern look at this below, colors little different but code looks better

Please Login or Register  to view this content.

[marreco]

And if I could get would be as automatic?

Thanks