VB to highlight select cells with a value

  • Thread starter Thread starter sowetoddid
  • Start date Start date
S

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
 
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
 
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)
 
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
 
Back
Top