VB to highlight select cells with a value

[sowetoddid]

Does anyone know a visual basic code that will...


Evaluate cells B154:K186 on whether or not they contain a value greate
than zero. If they do, then they should be automatically highlighte
in yellow.


I think that is pretty tough to do, but does anyone know how??


Thanks

 

[MAX258]

I don't know the VB code, but excel will do it for you using Conditiona
Formatting...

Format/Conditional Formatting
Set your condition and use Format to select highlight color.

Ma

 

[Bob Phillips]

Don't need VBA, conditional formatting will do it.

Select the cells, go into Format>Conditional Formatting, and use a condition
of greater than and a value of 0. Click the format button, select the
pattern tab, and choose your colour.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[sowetoddid]

I have tried using the conditional formatting tool, but how do I selec
the large range of data and also evaluate whether a cell has a valu
greater than 1

 

[sowetoddid]

Nevermind, I figured it out..

 

[sowetoddid]

Thank YO